Hi,
I have an access 2000 database. Every now and then a user will get an error message "This recordset is not updateable". When i have a look at their database i see the primary key is missing from one of the main tables.
When i change back to primary key the error goes away.
Sometimes when i go to reinstate the primary key the ID field has duplicate records. So then i have to look for duplicate records, remove them and then reinstate the primary key.
Can someone please tell me why the primary key would be removed from the table in the first place. Is there something i need to look for.
If anyone can give me any information to help this sort of issue i would be very grateful.
Regards,
Jim
I have an access 2000 database. Every now and then a user will get an error message "This recordset is not updateable". When i have a look at their database i see the primary key is missing from one of the main tables.
When i change back to primary key the error goes away.
Sometimes when i go to reinstate the primary key the ID field has duplicate records. So then i have to look for duplicate records, remove them and then reinstate the primary key.
Can someone please tell me why the primary key would be removed from the table in the first place. Is there something i need to look for.
If anyone can give me any information to help this sort of issue i would be very grateful.
Regards,
Jim