Sign In
Create Account
Follow Us on Twitter
Subscribe on Youtube
Can anyone teach me how to create backup and restore function?
The database is for the system itself, which means the database is currently open when the system is in use.
How to perform backup or restore? How to build such code?
3 replies to this topic
#1
Posted 16 February 2008 - 01:26 AM
mrbar
-
- Members
-
- 10 posts
Newbie
:D MRBAR
visit http://www.mrbar.net
visit http://www.mrbar.net
Back to top|
|
|
#2
Posted 16 February 2008 - 06:29 AM
WingedPanther
-
- Moderators
-
- 16,831 posts
A spammer's worst nightmare
If you just want the data, go through each table doing a "SELECT * FROM table_name" and save the results somewhere. You can restore using INSERT statements.
For table structure, you'll need to do a little research on how to extract the table names/fields.
For table structure, you'll need to do a little research on how to extract the table names/fields.
#3
Posted 16 February 2008 - 05:15 PM
mrbar
-
- Members
-
- 10 posts
Newbie
What I mean was I want to backup my whole database into a new file, like duplicating the database.mdb to another file named databackup.mdb and later I can use the backup file if the database file is damaged or corrupted.
:D MRBAR
visit http://www.mrbar.net
visit http://www.mrbar.net
#4
Posted 13 May 2008 - 01:50 AM
fyz
-
- Members
-
- 2 posts
Newbie
Hi,
Copy the mdb file and put in another place is very useful. Besides, sometimes the backup also will damage. I would liek to use a tool called Advanced Access Repair to repair my corrupt Access MDB files . With the both methods, the mdb file is more likely to keep safe.
Alan
Copy the mdb file and put in another place is very useful. Besides, sometimes the backup also will damage. I would liek to use a tool called Advanced Access Repair to repair my corrupt Access MDB files . With the both methods, the mdb file is more likely to keep safe.
Alan
