Software

Ask something
Discussion Locked

Access

0 helpful
4 replies

by lf king

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Need to know if a slow processor would make an access table duplicate a record number 600 times? The information is entered with a form with an auto number assigned to each record. 600 of those entries the auto number has changed from the originalto an old record number.

My developer has stated that the user needs a new pc because the pc is so slow it is replacing a new loan number with an existing one.

He also stated that you can't use the print selection feature without messing up the database.

4 replies

by bughunter

Your developer is blowing smoke! My guess is that the developer did not make the auto-number the "key" to the data base. If the auto-number were made the key and it was specified to be unique (no duplicates) then the system would not allow duplicate values. Why the duplicates were created is another matter and would require researching the record creation activity. For example; Your software may have different modules that need to be told to check record creation and that is not happening in a timely manner. Bottom line is that PCs only do what they are told, older PCs do exactly what they are told but just a little slower.

by bughunter

P.S. Ask your developer if 10 years ago all computer databases created duplicate record numbers!

This discussion is closed to new replies.