ADO
 

When I try to create a connection to an Excel workbook it
tells me that the workbook is already open (which it
is)...i.e.:

RS.Open SQL, Connection

If the workbook defined in the connection string is open
then I get a prompt...but I thought this shouldn't
matter! Further, I only get this message when running
from a network...at home, the Excel database can be open
or closed and I don't get the prompt.

Can I get around this?

Thanks,

Seth
..

ADO
 

Sounds to me like the network is disallowing the multiple instances of the
file to be opened, or the network copy of the Excel file doesn't allow it.
Probably the former. Generally speaking, though, you'll get better help in
the "Microsoft.Public.Data.ADO" newsgroup. I use ADO frequently myself, but
I would post there if I were having trouble.
HTH
Richard Choate

"Seth" wrote in message
...
When I try to create a connection to an Excel workbook it
tells me that the workbook is already open (which it
is)...i.e.:

RS.Open SQL, Connection

If the workbook defined in the connection string is open
then I get a prompt...but I thought this shouldn't
matter! Further, I only get this message when running
from a network...at home, the Excel database can be open
or closed and I don't get the prompt.

Can I get around this?

Thanks,

Seth
..