CopyDatabaseFile

[KodeKing]

Trying to use the CopyDatabaseFile method to make an archive of my database but keep getting

Run-time error '2046':
The command or action 'CopyDaatabaseFile' is not available now.

I have the ArchiveDatabase function stored in a module and am calling it from a for button.

Any ideas please??
Many thanks

 

[krunalprajapati]

u r trying to take a backup of the database using this method. then use below function.
Call Shell(Environ("COMSPEC") & " /C COPY 'database name with path' destination path and filename", 1)


for e.g.
Call Shell(Environ("COMSPEC") & " /C COPY c:\db1.mdb d:\db1.mdb", 1)

 

[ghudson]

Check this thread out... Back up and zip code from ghudson It will show you how to copy a db [even the db from which you are calling the backup code]. If you want to use the Zip function then ensure you have a "licensed" version of WinZip.

 

[KodeKing]

Zip Function!!!

Zip function is great! Thanks to the both of you