Saving a copy of database in another folder...

[Bruce]

What I am trying to do is on exiting the database, have
the database save to a local computer as well as a file
on the server. The only way I have accomplished this is
to manually drag from the loacl computer to the network
folder once a week. I would like it to be done
automatically upon exiting the database. Any suggestions
would be great.

Thank you

 

[Tony Toews]

What I am trying to do is on exiting the database, have
the database save to a local computer as well as a file
on the server. The only way I have accomplished this is
to manually drag from the loacl computer to the network
folder once a week.

When the user exits the FE attempt to rename the backend MDB
preferably with todays date in the name in yyyymmdd format. Ensure
you close all bound forms, including hidden forms, and reports before
doing this. If you get an error message, oops, its busy so don't
bother. If it is successful then compact it back.

See my Backup, do you trust the users or sysadmins? tips page for more
info.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm