Hello there,
the problem I face is the following.
I had to change the structure of a table which contained the contact data of people. Every record resp. person was given an Contact-ID by Autonumber. I had to create some queries to change the table, then copied the query into Excel and imported the whole thing back into Access as a table. (maybe a bit too laborious
The table is now there again with the wanted changes, but due to the export/import etc. the Autonumber-function for the Contact-ID field is gone. And of course, it can't be changed afterwards!
Can anyone tell me how to avoid losing the autonumber OR
if not possible to get a new autonumber which is the same as the old autonumber (means Contact-ID).
So far, I have to include a new Contact-ID next to the old Contact-ID.
Thanks in advance, Mike.
the problem I face is the following.
I had to change the structure of a table which contained the contact data of people. Every record resp. person was given an Contact-ID by Autonumber. I had to create some queries to change the table, then copied the query into Excel and imported the whole thing back into Access as a table. (maybe a bit too laborious
The table is now there again with the wanted changes, but due to the export/import etc. the Autonumber-function for the Contact-ID field is gone. And of course, it can't be changed afterwards!
Can anyone tell me how to avoid losing the autonumber OR
if not possible to get a new autonumber which is the same as the old autonumber (means Contact-ID).
So far, I have to include a new Contact-ID next to the old Contact-ID.
Thanks in advance, Mike.