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.
--
Ken Snell
http://www.accessmvp.com/KDSnell/
"JamesJ" <jjy@darwin_roadrunne0r.com> wrote in message
news:%(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Check out my code here:
>>
>> CompactBackendDatabaseFile_Custom
>> http://www.accessmvp.com/KDSnell/VBA....htm#CompactBE
>>
>> --
>>
>> Ken Snell
>> http://www.accessmvp.com/KDSnell/
>>
>>
>>
>> "JamesJ" <jjy@darwin_roadrunne0r.com> wrote in message
>> news:(E-Mail Removed)...
>>>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
>>>
>>
>>
Similar Threads
