I have an Access 2000 database that accumulates a large amount of data over time. I would like to put in an archive feature that exports records over a year old (or some other user-selected date) into an archive database. I then plan to have a modified front-end to run queries and print reports on the archives.
The problem I'm running into is that I'm trying to use the DoCmd.TransferDatabase method to export the necessary tables. However, for this to work, the new database must already exist.
I'm sure this is easy enough to do, but I can't seem to find the answer of how to do it. I've seen posts where people say they already figured that part out, but unfortunately they didn't explain how for little old me.
How can I programmatically create a new Access database file so that I can export my tables into it?
Thank you.
The problem I'm running into is that I'm trying to use the DoCmd.TransferDatabase method to export the necessary tables. However, for this to work, the new database must already exist.
I'm sure this is easy enough to do, but I can't seem to find the answer of how to do it. I've seen posts where people say they already figured that part out, but unfortunately they didn't explain how for little old me.
How can I programmatically create a new Access database file so that I can export my tables into it?
Thank you.