Lost Primary Key

S

Scott Watson

While filtering records in an Access Data file, an
unexpected message displayed, "Record is deleted". I did
not click 'OK', but closed the box. All records inthe
database still appeared to be listed. I looked in the
Student Table and noticed that the ID number field
displayed 0. In the table design, no primary key was
listed. Tried to reenter the Primary Key with no luck.
Thanks for your help
 
A

Allen Browne

If you used to have a primary key and it disappeared, then the database is
partiallly corrupt.

Create a new (blank) database.
Import everything *without* the relationships (Options button in the Import
dialog).
Recreate the indexes, and then the relations.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Access Access Record Order 0
One-to-one relationship 2
Autonumber records inserted in gaps 1
table with no primary key 12
referential integrity and tables 4
Do I need a sequential primary key? 7
Do I have to set the primary key to include primary key fields? 3

Top