Simple question

[mama16]

Hello, I have this table with a autonumber(PK). I just noticed that there are two rows missing. Didn't miss any data. My concern is where are the two rows? Will that create any problems later on?
This is what I mean,
525
526
527
528
529
530
533

Thanks

 

[KenReay]

Hi

Autonumber provide unique values, they are not guaranteed to be contiguous values

The are all kinds of reasons why values are "Missing", eg deleted record(s), click on AddNew record, then esc to abondon the creation of teh record, but will cause gaps in the sequence

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[mama16]

But is that ok? Should I worry about it?

 

[KenReay]

How can I possibly answer that?, it is the way Access/Jet works, does it match your requirement?

If yes then
' no worry
else
' worry
end if

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ellford]

Who has access to your database? Or should I say who has the required access to delete records? If you deleted 2 records, then this is normal as KenReay mentioned, it's the way Access works... Or if the users are able to delete records, then this is also okay as you've allowed this and they've deleted 2 records...

If nobody has deleted anything, then I'd be wondering what's up, as someone must have deleted them...

 

[PHV]

as someone must have deleted them
Not necessarly, simply aborted (canceled) a creation.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[JeremyNYC]

Have a look...

http://abcdataworks.com/id33.htm

---
Jeremy Wallace
METRIX Project Coordinator
Fund for the City of New York