am sorry for that inadequate info.
i want to backup my MS Access tables using vb6.0
I hope is clear now
I suppose you still need to decide what sort of backup regime is right for your data - I wouldn't know about that.
But on the technical side, it would be pretty simple to put together an Append or Make Table query to copy each table to a backup database. Or you could copy the MDB file, or probably numerous other options.
Restoring may be very simple or very complex, depending on what sort of restore capabilities you want. At the simplest end, you could just copy back the MDB file, overwriting the old "real" one. Then there are varying levels of complexity once you start looking at replacing tables, or individual records, and making decisions on which ones to replace, etc etc.
I think you need to define your requirements much better before you get into too much detail on how to achieve them. Basically, if you can define precisely enough what you want to do, the chances are very good that you can find a way to do it. And we can almost certainly help.
7
