scs wrote:
Thank you. I undersand what you are saying. If I close all forms in
my frontend the ldb file goes away in the backend directory. Could a
macro close all open forms and somehow copy that backend database
somewhere? Could I do it with VBA? Can you tell me how or point me
to more info on the subject.

You don't have to close all forms, only all forms bound to tables in the back
end. So you could still have a form opened that has a button that performs the
backup. Code in that button could loop through the Reports collection and the
Forms collection (backwards) closing all reports and all forms except for the
one running the code. Then the code can look for the presence of the LDB file.
If not found, make the backup copy. If found you can report that instead (which
would mean someone else might be in the file).

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com