Database is Duplicating Itself

[TimC]

I have just come to learn my database is duplicating itself (creatinga backup under the name Database, Database1, Database2, Database3, etc.) every time I exit from the program. How do I turn this feature off? Thanks.



Tim

[June7]

Only ways I know this can happen:

1. a runtime error in VBA causes the db to crash, a backup is created when Access shuts down

2. code intentionally saves backup http://mybusinessdatabase.com/vba-co...cess-database/

3. Windows OS is saving the backup http://www.ehow.com/facts_7574222_ac...ic-backup.html

[ItsMe]

Sounds like your database is crashing and then trying to recover, resulting in a backup copy.