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