View Single Post
  #5  
Old February 20th, 2006, 10:34 PM
Bob Miller Bob Miller is offline
Senior Member
 
First recorded activity by OfficeFrustration: May 2005
Posts: 358
Default

I create a Backup database and then use Make Table Queries to create tables in the Backup db of the linked tables in the front end. You can create a macro or code that runs each query from a switchboard or menu bar. I usually open a form that says "Running Backup" before opening the Make Table Queries and close that form after the last Make Table query has been run.
You can probably find some code somwhere that checks to see if the Backend is open before running the Queries.

Quote:
Originally Posted by scs
Thank you. I don't anticipate any more than two people using this at a
time. It's really going to be used primarily by one person. I mainly just
want them to be able to use it while I'm working on the front-end. However,
it will probably remain split in the end and used by two folks occasionally
at the same time.

I'm looking for a way that a user could enter the front-end and, through a
very user friendly interface, backup the back-end. If I'm understanding you
correctly, this would not be possible because the backend would be in use at
that time by that user.

I was hoping the user could make a quick backup of the data from within
Access before making a bunch of changes. I guess I'll have to develop some
other means outside of Access. Is this correct?

Thanks again.
snip