Runtime error 2147467259

B

BobbyKny

Runtime error 2147467259 Could not use", file already in use

I am running access 2003, with a split 2000 database. Front end and back
end, are both on our server. When I try to run it on a system with Access
2000 I get the above error and have to shut down. When I debug it, it always
points to :
Public Sub VerifyPassword(Password)
Dim rst As ADODB.Recordset
Dim db As ADODB.Connection
Set db = New ADODB.Connection
db.Open dbConnb <<<<<<<<< stops here

where dbConnb is defined as :

Public Const dbConnb = "provider=microsoft.jet.oledb.4.0;" & _
"data source=\\TSIFS1\Data\QAP\Mat_DR\meterdat_be.mdb"

This is the first instance that I actually try to access the backend tables,
so it shouldn't be in use. It works fine on mine and another system with
Access 2003.
Both are running XP pro. Any ideas??
Thanks,
 
B

BobbyKny

Just an update: I found that the permissions on the folder this was in
needed to be updated for this app. Once I changed the permissions, it worked
fine.
 

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