export Data from tables with link

[Guest]

Dear Friends,

In order to reduce the size of database (mdb file), I want to design a code
to export the unused data to the inactive mdb file for storage. As expected,
the tables are linked with primary key or index key.

What is the best way to export the data? The simply way to do so is making a
lot of query. Update query first and then delete query. But if I have 5
tables, I need at least 10 queries. It will be a big problem if something
conflict in the middle of export. Just few table is exported. Then a lot of
thing the admin is needed to handle.

There is still a lot more problems has been arisen in my mind. What is the
best way?

Regards,
Jack

 

[Douglas J. Steele]

I find it's seldom worth the trouble to archive the data. However, if you're
getting near the file size limit for an MDB (2 Gb for Access 2000 and
higher, 1 Gb for older versions), you may need to.

The safest way is probably to create your various queries and then wrap them
all in a transaction. That way, you can roll back the transaction if it
fails on any query. Of course, if you're dealing with huge amounts of data,
it's possible that you'll exceed the possible size for a transaction.