Backup/Archive the BE database

[Guest]

I have a database which was built to run a single process. At the completion
of the process I want the user to be able to make a copy the BE (with a
specific name) and clear all the data in the current BE in preparation for
the next processing. Each processing requires new source data which is
supplied prior to the run. I can not just keep adding to the current db BE
because of size limits (1.2 for a single year's data - compacted) I don't
want to rely on the user to make a manual copy and I want to ensure it is
done before the current data is cleared.

How do I make a copy of the BE from within Access VBA?

 

[Guest]

I don't think I was clear enough. the challenge will be figuring out where
the connected BE is located. (not the actual file copy) I can not be
positive it is going to be in the same folder as the FE. Is there a way to
determine the path of the current linked tables?

 

[Douglas J. Steele]

Take a look at CurrentDB().TablesDefs("NameOfLinkedTable").Connect, and
strip off the ";Database=" from the beginning.

 

[Guest]

CurrentDB("A_TableName").Connect works great.

thanks