mdb Save As using VBA

  • Thread starter Thread starter Rick
  • Start date Start date
R

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.
 
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.)
Click to expand...

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
 
Rick said:
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.
Click to expand...


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
 
Back
Top