E
egun
I have been working in a database that I assumed had the primary key [Program
ID] as an Autonumber field. Turns out the creator of the DB instead put in
some VB code that simulates Autonumber using the DMax function to increment
the primary key by one when someone creates a new record (he had his reasons
for doing this). This is causing havoc when there are multiple users
creating new records at the same time. Some users are having their inputs
rejected when they try to save them due to overlapping ID numbers.
I tried to go into the back end file and change the [Program ID] field to
Autonumber, but Access wouldn't let me, since there is already data in the
database.
I really want [Program ID] to be Autonumber. Does anyone have a nifty, easy
way to make that change to my back end file? I understand that I'll need
exclusive access to the file to make the change, but what else do I need to
do?
Thanks,
Eric
ID] as an Autonumber field. Turns out the creator of the DB instead put in
some VB code that simulates Autonumber using the DMax function to increment
the primary key by one when someone creates a new record (he had his reasons
for doing this). This is causing havoc when there are multiple users
creating new records at the same time. Some users are having their inputs
rejected when they try to save them due to overlapping ID numbers.
I tried to go into the back end file and change the [Program ID] field to
Autonumber, but Access wouldn't let me, since there is already data in the
database.
I really want [Program ID] to be Autonumber. Does anyone have a nifty, easy
way to make that change to my back end file? I understand that I'll need
exclusive access to the file to make the change, but what else do I need to
do?
Thanks,
Eric