Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Autonumber Primary Key - validation error!

Status
Not open for further replies.
maria28gr

maria28gr

MIS
Nov 20, 2000
15
0
0
GR
Hello to everyone,

The primary key (aa) in a table is autonumber (long integer). I checked the data in it some days ago and everything seemed to be ok, similar to the following:
aa name ...
... ... ...
1494 John ...
1495 Helen ...
1496 Eric ...
1497 Nick ...
1498 Mary ...
.... .... ...

Now I check them again and I see that the record with aa=1495 has been "replaced" by the record with aa=1498, so I see 2 records with the same aa, as in the following:
aa name ...
... ... ...
1494 John ...
1498 Mary ...
1496 Eric ...
1497 Nick ...
1498 Mary ...
.... .... ...

If I do compact and repair at the database, the field aa in the table is not anymore the primary key.

I can't understand how this happened.
Please help!!

Greetings,
maria28gr
maria.karakiza@usa.net
 
Status
Not open for further replies.

Similar threads

PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
112
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
148
dhookom
dhookom
KeyserSoze
  • Locked
  • Question
Import Error Files - Export$_ImportErrors
Replies
1
Views
52
Andrzejek
Andrzejek
VicM
  • Locked
  • Question
AutoExec throws error
Replies
6
Views
62
combo
combo
lameid
  • Locked
  • Question
Output to PDF - Adobe Protected mode error
Replies
0
Views
49
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top