cnn.open

[mklapp]

I am coding a form with a button. When I click the button, many data things are to happen. Currently


cnn.Provider = "Microsoft.Jet.OLEDB.4.0
cnn.CursorLocation = adUseClien
cnn.Open "Data Source=C:\Documents and Settings\mklapp.BCPS\My Documents\InterchangeServices.mdb

I get an error

Runtime error '-2147467259(800004005)': Could not use ''; file already in us

The form is in the DB I am trying to connect to and the db is set for default shared use.

 

[Yuan Shao]

Hello,

Thanks for your post. If I understand correctly when you opened an Access
database via codes, the following error message occurred.
"Runtime error '-2147467259(800004005)': Could not use ''; file already in
use"

Based on my research, it is mostly suspected that the destination database
has been exclusively opened by other applications. Please make sure your
shared destination database is not exclusively opened by any application.

Thanks for posting in community.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.