mdb Save As using VBA

[Rick]

I am trying to figure out how to write the code to "Save
AS" the entire mdb, for backup purposes. (Point it to
another drive and/or rename.)

Any help would be appreciated. Thanks, Rick.

 

[Bruce M. Thompson]

I am trying to figure out how to write the code to "Save

AS" the entire mdb, for backup purposes. (Point it to
another drive and/or rename.)

There is no "Save As" in Access. You can copy or compact the file to a new name
or location. Neither can be done while source database is open, however, so take
a look a Michael Kaplan's *free* add-in, TSI SOON, which can help you with
that - it's available at:

http://www.trigeminal.com/lang/1033/utility.asp?ItemID=8#8

 

[TC]

I am trying to figure out how to write the code to "Save
AS" the entire mdb, for backup purposes. (Point it to
another drive and/or rename.)

Any help would be appreciated. Thanks, Rick.

If your appliocation is split into a front-end/back-end structure, code in
the front-end can use a normal filecopystatement to create a backup copy of
the back-end (data) database, as long as no form, report, recordset or other
thing has the back-end open when that code is run.

The ability to do this, is one of the advantages of using a
front-end/back-end approach.

HTH,
TC