Pb9 how to implement the ACCESS database backup please introduce detailed point thank you

CodePudding user response:

Methods: file into test
Backup:
Ls_pathname for backup to save to what position, after is a path to the file

Ls_bfsql="BACKUP DATABASE DIRECTORY '" + ls_pathname +"' "

The EXECUTE Immediate: ls_bfsql Using sqlca;

//reduction: delete the original, now take an examination of the past
Disconnect;//disconnect from the database

Li_rtn=FileCopy (sle_filename. Text, gs_RunPath + "\ \ TMP db", true)

SetFileAttributes (gs_RunPath + "\ biothythm db," lu_attribute)//remove the read-only attribute

If FileDelete (gs_RunPath + "\ biothythm db")=false then//delete to restore the database before

Return
End the if


FileMove (gs_RunPath + "\ \ TMP db," gs_RunPath + "\ \ biothythm db")

CodePudding user response:

Connect the current application of ACCESS database copy out, is equivalent to a backup.

Restored to disconnect the current affairs and ACCESS first, and then you come over to restore the ACCESS kao after replacing, reconnect the transaction.

CodePudding user response:

General file and database synchronization software "synchronous experts online
"
Database synchronization presentation:
http://www.datsync.net/down.asp? File=download/dat demonstration. Rar& Name=database synchronization demonstration

Download the software:
http://www.ahjoe.com/prodnet.asp

File synchronization tutorial:
http://www.ahjoe.com/netdoc.htm

CodePudding user response:

FILYCOPY to define, is the API function