how could i back up my database if im using a Microsoft access database...? could that be applicable in ADODC>?? and how could i recover my database afterwards///?? please help me out...         

[Edited by elric on 01-08-2006 at 05:34 PM GMT]

____________________________
-same thing over and over again..-

Hi,
Why not just copy the mdb file. Then if you have a problem you can rename the copy to the active mdb name and your users will be connected to the undamaged copy.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

umm but could you tell me what to code,,,i need it to run in vb..im using an access database...

____________________________
-same thing over and over again..-

FileCopy "C:\MyDataFolder\MyDatabase.mdb", "C:\MyBackupFolder\MyDatabase.mdb"

If you need to restore the database just reverse the process and put the copy in the main folder in place of the corrupted database.


[Edited by GeoffS on 02-08-2006 at 08:53 AM GMT]

____________________________
multi-tasking - the ability to hang more than one app. at the same time.

don't i need to have a commonControl Dialog for this to work.. is this all the code.. just one line? heheh i know im asking too much.. but its a great help that someone answerd my call heheh.,,,      

____________________________
-same thing over and over again..-

Hi elric,
If you know where the database is, and where you want it to go, then this is the only line of code you need.
You would need the Common Dialog Control if you want to select the database source and backup locations at run time.
Alternatively, you could use the control to get the locations when you first run your program, then store them in a text file (or even the Windows Registry) then at backup time retrieve the values, and run the line of code to copy.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.