Saving databse

[steve_bris]

Saving database

Hi.

I need to add a button to one of the forms of my database that can save all the tables and stuff in the data base when u hit it and then with the click of another button the whole data base can be restored to that point.
Could someone please give me an idea how this type of funtion could be achieved.

Thanks
Steve

 

[WayneRyan]

Steve,

Don't know if life is really that easy.

You can use the Search Facility here and look for "Backup". GHudson has
had some good posts on how to back up databases. Maybe that's what
you need.

Wayne

 

[ghudson]

This might be of interest... Export All Database Objects Into Text Files

 

[modest]

Best thing to do is either use 2 database files. Or export your tables to a non-formatted text file (meaning not a word-processing file). You could possibly make the file names based on the time and date. This way you could bring up another form and possibly even pick your date you want to restore, instead of having just one restore point.

If you back it up within your database, it's going to make your database huge (depending on the amount of data you keep). However, this functionality is as simple as looping through your tables and exporting each one to their own separate files.

Then having another button that imports the files/tables to the one you use.

 

[shadow9449]

Hi.

I need to add a button to one of the forms of my database that can save all the tables and stuff in the data base when u hit it and then with the click of another button the whole data base can be restored to that point.
Could someone please give me an idea how this type of funtion could be achieved.

Thanks
Steve

I had a thread in December about roll forward recovery. It's more versatile than creating restore points because it doesn't require action from the user.

Do a search for it. Some of the ideas that people (i.e. Pat) suggested were very helpful

SHADOW