Back-Up Back-End Database

[JamesJ]

I have a back-end database for my data only.
Is there a way to back it up directly from my front-end db in Access 2007?
I see no commands that I would interpret as such.
I'm trying to avoid closing one db and open the back-end to back it up.

Thanks,
James

 

[Ken Snell]

Check out my code here:

CompactBackendDatabaseFile_Custom
http://www.accessmvp.com/KDSnell/VBA_Functions.htm#CompactBE

 

[JamesJ]

I understand that 'strPathFilename_OriginalBEDB As String' is the path to
my backend db.
What is 'strPathFilename_TemporaryBEDB As String'?
Should that be the destination path of the copy?
And 'blnKeepBackup As Boolean', Should I set this to 1?

James

 

[Ken Snell]

That is the path and name that you want the function to use for the
temporary backup copy of the backend database, before it compacts the
backend database file. If you want to keep the copy as a permanent file for
archival purposes, then the function won't delete that file when it's done
with making the backup.

If you want to keep the copy of the backend database file, use -1 (which is
ACCESS' value for True), else use 0.