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.