Sudden problem with access lock file

  • Thread starter Thread starter AndyNakamura
  • Start date Start date
A

AndyNakamura

Guest
I have an application which is a vb.net front end connecting to a .accdb database backend.

I've suddenly started getting errors in my application which are (I'm pretty sure) to do with the .laccdb file that is created when a connection is made to the database. When I am trying to backup the database I get an error:

Microsoft Access Database Engine-->You attempted to open a database that is already opened by user 'Admin' on machine 'MYMACHINE'. Try again when the database is available.

When I look in the directory with the database there is the .laccdb file even though I closed the connection. If I try and delete the file I get 'You can't delete this file because it is open in 'MyProgram'

I've checked the connectionState and it is closed. It's just that the lock file hangs about for ages - up to 5 mins - then closes.

Has anyone else noticed this? I've been using this prog for a number of years then suddenly started happening today. It also not just one computer I get the same on my other machines.

Continue reading...
 

Similar threads

A
Replies
0
Views
78
Ashkan Satarpour
A
D
Replies
0
Views
768
DexterCamarillo
D
D
Replies
0
Views
714
DexterCamarillo
D
D
Replies
0
Views
305
DexterCamarillo
D
Back
Top