Access from Excel ADODB.Connection

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)
 
P

Pictou

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top