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