I need to know how to specifiy that an ADODB connection is NOT exclusive
dim dbconn as ADODB.Connection
set dbconn = new connection
dbconn.open [connect string], [userid], [pwd], option?
I can not find documentation for options in help or whatever.
Is there an option to make sure this is not an exclusive connection.

I am having a problem with the following failing with a note that the
database is missing or opened as exclusive by someone else. I have the
ADODB.connection object and an ADOX.Catalog object open when the following
executes.

dim acc as Access.Application
set acc = new Access.Application
acc.OpenCurrentDatabase [database path], False, [pwd]
(False meaning not exclusive)

I should add to the following that this bit of code works, but it does not
give me an Access.Application object to work with.

Dim db as Object
set db = acc.DBengine.OpenDatabase([file path], False, False, ";PWD=password")


"Pictou" wrote:

> I need to know how to specifiy that an ADODB connection is NOT exclusive
> dim dbconn as ADODB.Connection
> set dbconn = new connection
> dbconn.open [connect string], [userid], [pwd], option?
> I can not find documentation for options in help or whatever.
> Is there an option to make sure this is not an exclusive connection.
>
> I am having a problem with the following failing with a note that the
> database is missing or opened as exclusive by someone else. I have the
> ADODB.connection object and an ADOX.Catalog object open when the following
> executes.
>
> dim acc as Access.Application
> set acc = new Access.Application
> acc.OpenCurrentDatabase [database path], False, [pwd]
> (False meaning not exclusive)
>