try setting up your tables in your new back end SQL or MySQL I don't know which from your post enter some test data to see if your autonumber feature is working, then delete that information and import your access information into those tables and see if your primary keys are preserved, if they are, you're home free, if they're not you will likely have to delete the data you just imported, add another field like 'newpk' make this your autonumbering field in SQL, import your data then for all the child tables for each table you'll have to go through and modify the parent ID field from the old to the new numbering system.
For instance if you originall had this:
Code:
People
PeopleID PeopleName
1 PersonA
3 PersonB
4 PersonC
PeoplePhones
PhoneID PeopleID PhoneNo
1 1 111-222-3333
2 1 111-222-4444
3 3 333-444-5555
4 4 444-555-6666
And after your import of your people table you had this:
Code:
People
PeopleID PeopleName
1 PersonA
2 PersonB
3 PersonC
NOTE the autonumber removed a place
Then you'd have to reimport and allow for a changing people ID with something like this
Code:
People
OldPeopleID PeopleName PeopleID
1 PersonA 1
3 PersonB 2
4 PersonC 3
Then import your phone number table and anyplace where the personID appears you would have to update with the NEW peopleID.