Runtime error 2147467259

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

Guest

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,
 
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.
 
Back
Top