back up

[Steve S]

Hi:
I have numerous Access 2003 front apps tied to a single back end. On a few
of the front end apps, when closed, a backup copy is automatically made of
the app in the same folder. Some are named the filename of the app with the
word "backup" added and some backups are named "db1". This is really
becoming a nuisance. Can anyone tell me why this is happening and/or how to
stop it. Nothing in the VB code prompts this. All of the front end apps are
identical...some do this and some don't.
Thanks in advance,
Steve

 

[S.Clark]

From memory...

There is an option called 'Compact and Repair on Exit'. Maybe it's this one,
or there may be another one that does a backup on close.

The other option is when Access crashes, it will perform a backup. Is it
crashing on close?

 

[Steve S]

Thanks for the quick reply. How can I tell if it's crashing? All data
entered by the end-user is saved and nothing is lost. The end user isn't
receiving any error messages.

 

[Tom Wickerath]

I think what Steve Clark was advising is to ensure that the Compact on Close
option is not enabled. You really shouldn't need it, if your front-end
application is designed properly.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________