Access from Excel ADODB.Connection

  • Thread starter Thread starter Pictou
  • Start date Start date
P

Pictou

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")
 
Back
Top