Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Primary Key IDs

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Primary Key IDs

Resolved · High Priority · Version 2007

Reply 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

For upcoming training course dates see: Pricing & availability

Reply 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

Reply 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

Reply 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?

Regards

Simon

Reply 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

Reply 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

Reply Thu 24 Mar 2011, 13:50Delegate Robert said...

RE: Primary Key IDs

Hi Simon,

Thanks for your help.

Regards,
Rob

Access articles

· Access VBA Training Adds Power to your Databases
· Microsoft Access Cheat Sheet: Tips and Shortcuts
· Getting to grips with Access 2007's Opening Screen and User Interface
· Want To Get Started With Macros In Microsoft Access?
· How To Take Control Of Your Data And Save Money In The Process

Please browse our web site to find out more about
access class microsoft training and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips