Backup in Access

  • Thread starter Thread starter Sergey Bogdanov
  • Start date Start date
S

Sergey Bogdanov

Hello,

Is it possible to call "Save as..." dialog window to backup my MDB file. I
mean is there any method for backup'ing my MDB file? If it help, MDB file
with all tables is separated from the interface and used as "linked tables".

--Sergey
 
Sergey Bogdanov said:
Hello,

Is it possible to call "Save as..." dialog window to backup my MDB file. I
mean is there any method for backup'ing my MDB file? If it help, MDB file
with all tables is separated from the interface and used as "linked tables".

--Sergey
Click to expand...


There is no File : Save As, as such. However, your application is apparently
split into a "front end" database (what you call "the interface"), and a
"back end" database (what you call "the tables"). Just write some VBA code,
in the FE database, to make a copy of the BE database, using normal VBA file
copy statements. (FileCopy? - I don't have Access here to check). Ensure the
BE database is not open, when you copy it. (That is, make sure no forms,
reports or other recordsets are open, when you call your copying code.)

The ability to write such backup code, is one of the advantages of having a
FE/BE structure. If the database is "all in one", it can not create a
reliable backup copy of itself.

HTH,
TC
 
There is no File : Save As, as such. However, your application is
apparently
split into a "front end" database (what you call "the interface"), and a
"back end" database (what you call "the tables"). Just write some VBA code,
in the FE database, to make a copy of the BE database, using normal VBA file
copy statements. (FileCopy? - I don't have Access here to check). Ensure the
BE database is not open, when you copy it. (That is, make sure no forms,
reports or other recordsets are open, when you call your copying code.)

The ability to write such backup code, is one of the advantages of having a
FE/BE structure. If the database is "all in one", it can not create a
reliable backup copy of itself.
Click to expand...

Thank you for you answer. But still I can't open "Save as..." dialog that
user could point the location for backup. It's importat before I invoke
"FileCopy" function.
 
Back
Top