Saving a copy of database in another folder...

  • Thread starter Thread starter Bruce
  • Start date Start date
B

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
 
I run a bat file as a startup when I start my computer to do all my copy
work. That way I don't forget and it keeps everything fresh.

I would guess you could do much the same idea by running a bat file to
start access and then when the control returns to the bat file it could then
start the copy. The problem with doing it from Access is Access has the
program open and coping an open program is a problem.
 
Bruce said:
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.
Click to expand...

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
 
Back
Top