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.
"Douglas J Steele" wrote in message
...
All you have to do to backup the back-end database is to copy the MDB
file.
However, you need to ensure that you do this when no one is using the
back-end database. Otherwise, you run the risk of your backup being
inconsistent, and hence of little use to you.
You can tell whether anyone's using the back-end by looking for the
locking
file. If anyone's using the back-end database, the locking file will have
the same name as the database itself, but with an extension of .LDB,
rather
than .MDB, and will be in the same folder as the back-end MDB file.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"scs" wrote in message
...
I did a little searching in the groups but have been unable to find this
information. If someone could offer advice I would really appreciate it.
I have split the database so that multiple people can use it and so I can
continue to develop the front end. I want a button on my swithcboard to
back up the database . I have no problem with that, a simple macro
accomplishes this. My problem is I need away to backup the actual linked
tables int the backend too.
I played around with open database command in macros but I don't
understand
what's going on. Any thougts or ideas on the best way to accomplish
this.
TIA