We keep losing primary keys.
The situation appears to be this:
We have got a small network (30 users) with all our MS Access 2000 SR-3, Jet4, databases in one shared folder on our NT server.
The databases the users access mainly contain link tables. Our main tables are located in ‘parent’ databases, never accessed directly by the users.
Last Friday morning, users couldn’t update any records because the link table they were trying to update had lost its primary keys. We put the primary keys back into the original parent table and it seemed to work fine (see. Microsoft Knowledge Base Article 304179) …. till this morning when the same thing happen again.
After checking backup copies of the parent databases it appears that the primary key disappeared overnight.
Don't know if it's directly related to our problem but maybe you need to know these extra points:
- Databases are compacted directly from the NT server (via a scheduled batch file) every night.
- We have been manually compacting and repairing the databases quite a few times over the last weeks since we migrated to Access 2000 and we keep crashing (‘Unrecognised database format’, ‘Action reset current code in break mode’, ‘ Invalid Argument’ etc.). I believe that the primary key problem was there before the migration (after checking our backups one of the primary keys missing last Friday was not there before we changed from A97 to A2000).
Any idea why the primary keys keep disappearing?
Does that ring a bell to anyone – Anyone having the same problem?
Any help is appreciated,
Thank you in advance,