DB_Backup.MDB file has appeared beside DB.MDB.

[Guest]

I have a local DB.MDB which accesses a DATA.MDB on a network drive.

I use a user-level security file.

It has been working AOK for a year or so.

Yesterday one of the users reported an error dialog when attempting to open
the DB.MDB (unfortunately the wording of the dialog was not captured!)

After this 'event', the database started working correctly once again.

The result was a DB_Backup.MDB file appeared beside the DB.MDB.

Any ideas?

 

[Guest]

The backup is usually automatically created when someone tried to compact and
repair the database without success. In that case the original might be
damaged although it seems to be working ok. My advice is to make another
backup copy from the version prior to the backupfile (you do have that don't
you?).

 

[Ken Snell \(MVP\)]

That backup file is created when ACCESS "crashes" during use.....