troubleshooting Question

Archive Records in Access from one DB to another DB

Avatar of Lee R Liddick Jr
Lee R Liddick JrFlag for United States of America asked on
Microsoft AccessVisual Basic.NET
7 Comments2 Solutions478 ViewsLast Modified:
I have a database in Access (DB1) with a table (TABLE1) that holds data that continuously gets added upon.  There is an issue when opening TABLE1 that the length of time is getting longer and longer (yes I already know if this is the problem, move it out of Access and into DB2 or SQL or something, etc. but I do not have that option at this time).

I have created a form in DB1 that basically has two inputs, one for a beginning date and one for an ending date that the end user can choose in order to move older data out of TABLE1 into DB2 (the archived database) into TABLE2 (holding just the old archived data from the main database.  The user then clicks a button and I need to move the records (so basically copy the records) within the date range the end user entered to TABLE2 in DB2 and then delete these old records in TABLE1 of DB1.

My problme is that I am not sure how to write the macro or whatever to make this happen.
Join our community to see this answer!
Unlock 2 Answers and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros