E
Emma
Can someone tell me what an laccdb file is?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jeff Boyce
Emma
Access creates/opens a 'locking' file when you open an Access database, to
help it keep track of who's using the db.
The 'native' file format for Access 2007 is "accdb", hence it's
corresponding locking file is "laccdb".
Regards
Jeff Boyce
Microsoft Office/Access MVP
Access creates/opens a 'locking' file when you open an Access database, to
help it keep track of who's using the db.
The 'native' file format for Access 2007 is "accdb", hence it's
corresponding locking file is "laccdb".
Regards
Jeff Boyce
Microsoft Office/Access MVP
E
Emma
Hi Jeff,
Why have I never noticed this before? I also noticed that today while the
lock was on I could update the backend but previous times I've tried I
haven't been able to . The only way I knew someone was in the database was to
see if there were 2 security files. Can you explain to me the proper way as I
want our data to be as accurate as possible.
Why have I never noticed this before? I also noticed that today while the
lock was on I could update the backend but previous times I've tried I
haven't been able to . The only way I knew someone was in the database was to
see if there were 2 security files. Can you explain to me the proper way as I
want our data to be as accurate as possible.
E
Emma
So Jeff,
Does that mean one of my users openned it in exclusive mode? If so how do I
resolve this?
Thanks again
Emma
Does that mean one of my users openned it in exclusive mode? If so how do I
resolve this?
Thanks again
Emma
J
Jeff Boyce
Emma
In my experience, I very very rarely need to do anything with the "locking"
file. Access generally handles it.
The one exception has popped-up when Access dies an inglorious death and
forgets to clean up. In that one instance, the locking file is left hanging
after the application is closed (i.e., died). If you don't delete the
locking file in that instance, Access gets terribly confused.
Sometimes when I've tried to delete the locking file, Windows won't let me
.... and correctly so! If someone is using (i.e., has opened) an Access
application, you should logically NOT be able to kill the locking file.
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP
In my experience, I very very rarely need to do anything with the "locking"
file. Access generally handles it.
The one exception has popped-up when Access dies an inglorious death and
forgets to clean up. In that one instance, the locking file is left hanging
after the application is closed (i.e., died). If you don't delete the
locking file in that instance, Access gets terribly confused.
Sometimes when I've tried to delete the locking file, Windows won't let me
.... and correctly so! If someone is using (i.e., has opened) an Access
application, you should logically NOT be able to kill the locking file.
Good luck!
Regards
Jeff Boyce
Microsoft Office/Access MVP