98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Primary Key IDs
Primary Key IDs
Resolved · High Priority · Version 2007
Fri 11 Mar 2011, 10:35Delegate Robert said...
Robert has attended:
Access Intermediate course
Primary Key IDs
I'm trying to add a new entry into the database. Previously this would be done either by form or in the table itself, and a new ID would be generated for the new entry.
However now, it is generating duplicate numbers on the ID and creating errors. I have looked in design view > indexing and 'no duplicates' is turned on.
Please advise
Mon 14 Mar 2011, 14:14Trainer Simon said...
RE: Primary Key IDs
Hi Robert,
Thank you for your question and welcome to the forum.
What is the Data Type for the field? Maybe the number of records have exceeded the maximum amount.
Regards
Simon
Mon 14 Mar 2011, 14:21Delegate Robert said...
RE: Primary Key IDs
Hi Simon,
Thanks for the response.
The data type for the id field is autonumber, field size long integer and new values are increments. The record numbers aren't in excess of 3000
Regards,
Rob
Tue 22 Mar 2011, 13:23Trainer Simon said...
RE: Primary Key IDs
Hi Rob,
Is it possible to send me a copy of the database to sk@stl-training.co.uk?
Regards
Simon
Tue 22 Mar 2011, 14:32Delegate Robert said...
RE: Primary Key IDs
Simon,
Would rather not as the database contains sensitive information. However, I somehow managed to rectify the issue today by just saving a copy. However this copy is now about half the file size of the original yet no data is missing.
Understandably I am happy but this does strike me as rather odd. Do you have any insight into this?
Regards,
Rob
Thu 24 Mar 2011, 13:47Trainer Simon said...
RE: Primary Key IDs
Hi Robert,
Thank you for your response.
It may be that the database was compacted on close which may have contributed to the smaller file size.
Regards
Simon
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
