I have an Access 2002 app spilt into front and back-end MDBs. I'm trying to write a function that will archive data on the back end once a year. My first though was to use the CopyObject function to create a new copy of my table, give it a new name, and then delete records to prepare for a new year of data entry.
However, because I'm running from the front end, the CopyObject only sees my link to the table, not the table itself, so it ends up copying a link of my table to itself in the back-end mdb. Any way to copy the table itself without resorting to SQL code that will append all the records?
thanks
However, because I'm running from the front end, the CopyObject only sees my link to the table, not the table itself, so it ends up copying a link of my table to itself in the back-end mdb. Any way to copy the table itself without resorting to SQL code that will append all the records?
thanks