Problem of Access 2003 creating duplicate copies itself

B

basara

hi,
I just updated my Access to 2003. Now everytime when my pc goes to screen
saver mode, the system itself will create a duplicate copy of my current
database which is open. I guess it is to prevent database corruption or
something. But i don't want to see so many duplicate copies. I have to delete
it everytime. Is there a way to turn off this feature?

thanks.....
 
G

Graham R Seach

This isn't a feature, and I can't see how it is possible for Access to do
this, unless you have code that specifically does it. Are you sure you're
not seeing the lock file (*.ldb)? If so, then this file is necessary when
Access runs, and should not be deleted unless you have crashed the database,
and even then, only if the database is closed.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
B

basara

hi,

i am pretty sure. It is not the one with .ldb extension. When my database is
named POS.mdb, the System will create a POS1.mdb if i leave the database
running while I didn't touch my PC for somewhile and it goes to power saving
mode.
 
Top