I’m running MS Access 2003 and the database is used on a network between 20 to 30 people (5 or 6 at the same time). We’ve recently started seeing duplicate renamed copies of the file in the folder on the server drive. I originally thought someone was doing this intentionally but that’s not the case. Somehow the database is creating these? Not sure how to fix it? Any ideas?
It usually happens during normal report running, nothing excessive, no long queries, maybe 3 or 4 users on at a time when it happens. Database size is around 27MB when compacted.
this is not the .ldb file
There is actually a separate .mdb file being created with "_Backup" added at the end of the file name
Related posts:
1 response so far ↓
1 Armageddon Saviour (Siddharth) // Sep 11, 2008
Access makes small file (few kbs) *.ldb (same name different extension ) a Lock file when database tables are opened.
It gets deleted when you properly close the database file.
So you then see the original big file *.mdb alongwith this one…
And you might be thinking, duplicate renamed copies of file being created …
Alt+V –> Details
have a detailed view of the folder & keep refreshing rapidly with F5 key.
You will notice
It’s normal.
Leave a Comment