Check if the file is read only, if it was remove it
This generally happens when someone opens Access to create a new database but doesn’t name it.
So the system is forced to name it different from any existing database file.
Are you saying that these files contain a copy of the data or are they blank databases?
These files contain a copy of the data.
It sounds like the tools-database utiltiies backup database or compress database is being run
but I cannot find a setting to make that automatic — part of a macro or VB script perhaps.
Could be part of the database startup or form?
I was out of town for about 2 weeks & intentionally did not connect to this site!!!
Now I am noticing nice questions and answers. I will spend some time to answer some of the queries – that I feel comfortable to lend support.
On this question – I am assuming this is related to Access 2007. Since it is on a shared drive – the system administrators may have set a code to take a backup as database is changed on User exit. Also there are options to log all changes. May be the changes are really log files. So the options to investigate will be to:
1) Check with system administrators if they have set up to take automatic back up on exit.
2) Check the database mdb12 – is this is a complete database? In other words what is the difference between mdb11 and mdb12?
3) As for compressing the database – I highly recommend it (Access database gets too much bloated with normal use. In Access 2007: 1) Click on the Office Button 2) Click Access Options (bottom right) 3) Click Current Database (from list on left side) 4) Check “Compact on Close”.
Note: after typing this message – I noticed that this is more likely related to Access 2003 – since this is a mdb file.