cnn.open

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Hello,

How is the issue going on your side? Please feel free to post in the group
if my suggestions address your problem or if you would like further
assistance on this issue. Based on my test, even if the database is set for
shared used, we can also exclusively open it. Therefore, before open the
destination Access database, please make sure it is not exclusively opened
by any other bodies or applications.

I am looking forward to hearing from you soon.
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.
 
Back
Top