Copy an Access database when open using command button

Question

Hi,

Is it possible to open an Access database, add records, change data or whatever and then have a command button in the program that would ask for a drive letter (ie C:, D: .....) and then copy the opened database to the entered drive?  If so, would the change be saved?  Also, if this is possible, how?

Thanks

Phil

Answer 1

Depends on what you're trying to do.

All Access applications (even single-user applications!) should be split into a front-end (containing the queries, forms, reports, macros and modules) linked to a back-end (containing the tables and relations). If you ensure that there's no connection to the back-end (i.e.: no bound forms or reports are open), you should be able to copy the back-end using the built-in VBA FileCopy statement.

Answer 2

Just to briefly add to Douglas' answer.

For the FileCopy to work, as dougls states, need to be done when there are no active connection to the database.  Hence you can use DIR statement to check for a lock file (ldb, laacdb, ...) in the database directory, if none exists then it is safe to make the copy, otherwise, it means someone is actively in the database and a copy should be made at another time.