exporting specific data to another access db

[Guest]

Hi there

I have audit logs which track all changes, updates and deletes to specific tables. These tables grow very fast. I have to keep the data collected in these tables for QA purposes, but i want to be able to monitor these tables such that I can export chuncks of data (date ranges) to an external Access database and burn the data to disc. There are several audit logs i need to do this for.

Does anyone have any suggestion on how i could go about doing this programactically

Thanks for the help

Carlee

 

[Joe Fallon]

Do it manually first.
See if it works.
Then automate those steps.

It is actually very simple.
Just write an Append Query from one Db to another.
In the screen where you choose the Table to append to - STOP and read it.
Check the other radio button - the one that says Another Database.
Add the path to the other MDB.

Then test it by appending a set of records to the other file and then
deleting the same set in the original mdb.
(Use copies of the files for testing!!!)
That is 2 queries.

The call them in code from a form so you can set the date range on the form
and it should be a matter of clicking a button to do what you want.



--
Joe Fallon
Access MVP

Hi there,

I have audit logs which track all changes, updates and deletes to specific

tables. These tables grow very fast. I have to keep the data collected in
these tables for QA purposes, but i want to be able to monitor these tables
such that I can export chuncks of data (date ranges) to an external Access
database and burn the data to disc. There are several audit logs i need to
do this for.

 

[Guest]

worked well...thanks for your help!