Automatic Backups

[Vandy Ltd.]

A former employee created a database called Requests.mdb.
In the same folder are other databases named db1.mdb,
dvb2.mdb, all the way to db9.mdb. Basically, all of these
files are backups of the original database at certain
times; they are not replicated databases. I know that no
one is backing up the database themselves, it is somehow
being done automatically.

I haven't been able to determine how this is being
done...and i actually want to do the same thing with some
other databases.

Anyone know how this could be happening?

 

[Joan Wild]

These are likely failed compacts. Perhaps the database is set to compact on
close (Tools, Options menu). The compact process creates a new database
(db1) and then deletes the original and renames db1 to the original name.

It sounds as though the user does not have delete permission in the folder,
and so the db1 is left. The next compact will create db2.

 

[Vandy Ltd]

That option, compact on close, is not set in my Access.
But, it could have been set in the users' Access. The user
no longer works here, so he no longer has any permission
at all.

I wonder if somehow, Access remembers that this person
created the DB, although his name is not listed in the
permissions, and it still has his settings and all of that.

I might try to create a fresh database and import all of
the data, then check to see if it happens again.

Thanks for the point in the right direction.