By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,479 Members | 1,548 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,479 IT Pros & Developers. It's quick & easy.

Archive access table to another access databse

P: 48
hello all

after creating an audit trail for my access database, ive realised that the size of the audit table is increasing very fast and i would like to transfer the contents of the audit trail table to a separate database. how can i do this. im using access 2003 and the database is in an mde format is unsplit and on a network share.
thanks
Oct 9 '08 #1
Share this Question
Share on Google+
5 Replies


DonRayner
Expert 100+
P: 489
Backup your database then do the following

Create another database and "import" your audit table into it, save it. Go back to your origional db and delete the audit table then you create a link to the audit table in the new database. give it the same name as the origional table and everything should be working great.
Oct 9 '08 #2

P: 48
Backup your database then do the following

Create another database and "import" your audit table into it, save it. Go back to your origional db and delete the audit table then you create a link to the audit table in the new database. give it the same name as the origional table and everything should be working great.
thanks for the quick reply, ive manged to import the audit table to a new database but when i tried to delete the table in the original database it won't let me because my audit table has a relationship with one of the other tables (main table) in the original database. i can delete the audit table once the relationship is also deleted, but will i be able to re link the relationship with the audit table in the new database and the the main table in the original database?
Oct 9 '08 #3

DonRayner
Expert 100+
P: 489
thanks for the quick reply, ive manged to import the audit table to a new database but when i tried to delete the table in the original database it won't let me because my audit table has a relationship with one of the other tables (main table) in the original database. i can delete the audit table once the relationship is also deleted, but will i be able to re link the relationship with the audit table in the new database and the the main table in the original database?
In short... Yes you can

But you will need to create the linked table first
Oct 9 '08 #4

P: 48
hey
ive just tried it out and deleted the relationship and created a new relationship with the linked audit table and it worked fine. can i just ask, how often will i need to refresh the link to keep the audit table up to date or is that done automatically. thankyou so so much again.
Oct 9 '08 #5

DonRayner
Expert 100+
P: 489
hey
ive just tried it out and deleted the relationship and created a new relationship with the linked audit table and it worked fine. can i just ask, how often will i need to refresh the link to keep the audit table up to date or is that done automatically. thankyou so so much again.
Everything is automatic. The link that you just created is ecactly how a split database works, except in a split database all of the tables would be links

Glad I could help
Oct 9 '08 #6

Post your reply

Sign in to post your reply or Sign up for a free account.