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