Software

Ask something
Discussion Locked

Access 2000

0 helpful
4 replies

by jgthompson1

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am having a problem with the primary key coming off of a table. I have the primary key on an autonumber field. I am running Access across a LAN. Any suggestions on correcting this problem?

4 replies

by raffi_

I do not understand "coming off of a table". Are you saying that you set the key and that ir does not accept it in design mode? Or does the key go corrupt or are you having trouble acessing the key via queries and reports?

Please advise

Regards
Raffi_

by jgthompson1

I set the primary key on a table, but over time, let's say a couple of days and a couple hundred records added, the primary key "falls off". When this happens, duplicate records are allowed, I then have to close the database, search for the duplicates, and then "reset" the primary key. All my users are running Access 2000 with SR-1.

This discussion is closed to new replies.