Access 2002: How to Backup Files (Docmd.CopyDatabaseFile)

[dreman]

I have an application that I would like to have a click command to backup database file.

I am using Docmd.CopyDatabaseFile but I keep on getting an error that this command is not available (error 2022)!

Please advise.
Thank you.
dré

 

[Bullschmidt]

Well you could copy out tables individually with TransferDatabase if that helps any.

Best regards,
J. Paul Schmidt - Freelance ASP Web Developer

http://www.Bullschmidt.com

- Creating "dynamic" Web pages that read and write from databases...

 

[JR2913]

Have you tried

FileCopy strSource, strDest


where strSource is the back end database and strDest is the name of the destination file (and path). I use this to create a copy of the backend file with the date of creation added to the backend filename.

John R

 

[dreman]

I dir try:
filecopy table, backup
it is giving Microsoft Access error file not found error (53)
remeber that table is a database table, I need to back up the table.
Please advise, thank you
dré

 

[JR2913]

Dreman

In you first post you state that you want to backup a database file, not a table. Filecopy won't work with a table. In the example I gave above, it is used to backup a split database, backing up the backend data into a new (datestamped) file in a different location.

John R