Database integrity issue

[toyt78]

I have an Access 2000 database that is a backend to my Cold Fusion application. Just recently someone tried to enter data with invalid info and the Record number kept increasing until valid info was entered so now I have a skip (from Project ID 2 to Project ID 8) in my Project ID Number:

Project ID(primary key)   Name
1                         Smith 
2                         Jones
8                         Richards

The database and web application and queries still work great but was wondering if any future damage can happen to my database? It is currently at 10 MB in size.

 

[r937]

the "skips" or gaps between autonumbers don't matter at all

you might want to compact the database from time to time



r937.com | rudy.ca

 

[Crowley16]

r937 is correct...

IF your projectID is a autonumber, then it doesn't matter.

The point is, you have to stop thinking that the auto number means anything at all, it is JUST a field which contains a set of automatically generated UNIQUE values, as far as you're concerned they could be a load of gibberish, e.g. als;kdjfa9s8dy7flwer92364 and it still wouldn't affect your data integrity

--------------------
Procrastinate Now!

 

[lespaul]

Now if you need a sequential tracking of projects, you can add another field to the table to do that. but the autonumber should be meaningless.

leslie

 

[toyt78]

Thanks for all the info!