Back up a Split Database's Backend
Thanks! That's pretty easy and works well.
"Bob Miller" wrote in message
. ..
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.
scs Wrote:
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
--
Bob Miller
|