Saving a databse in vb6

Not sure about your question. If you are really trying to put an Access 2002 format to an Access 2000, you may not succeed as there are bound to be differences and your direction is backwards (not usually normal to go from higher to lower an usually unsupported by vendor). If you got the dates wrong (going from 2000 (or lower) to 2001, then there is hope).

Do you really have to do the save in VB? Why not do the tabel save from Access where you have some flexability and less complexity (Access to Access)?

Check that the format of the tables, characteristics/attributes, etc. of both databases (tables) are the same. Probably the reason it is crashing.

Answer #1 is correct, you need to select records (in a set or one at a time) from one database then add/update them in the 2nd one record at a time (may get an SQL that will do this as a single step, but ...). If you use the utilities in Access import / export / etc.) it will do this for you.

If the actual save process can be done, (you have a 2000 you want to get to 2002 or some such), you may be able to resolve by putting the older db on a compatible system and doing the conversion. If you are on 2002 and have a 2000 or older, there should be a conversion option thatwill let you upgrade the older format to the newer (make a copy of the older file and convert that or otherwise setup so if it doesn't work, corrupts, etc. you can get the original back. I did open old, convert, save as until I was somewhat satisfied that it would work).

Lastly, it may not be possible to do the save in VB as if you are using 2 different versions of Access. VB may not be able to work with both at the same time.