I’m trying to solve a problem in which I have a currently set up database with relation ships and processes and ect. My problem is the data is old and I need to completly clear the records and bring in new data. So far what I found to do this task hates the relationships and tries to write to the primary key causing failed imports.
Anything that I can add to my list to try with an import/purge.
I have sql 2005 with access 2000 database.