Backup in Access

[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

 

[TC]

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

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

 

[Sergey Bogdanov]

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.

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.

 

[Andy Cole]

Sergey

Use the code at;
http://www.mvps.org/access/api/api0001.htm

to perform the API call to the standard "Open/Save" dialog - this works in
all versions of Access

HTH

Andy