Access

Resolved · Low Priority · Version 2003

Mon 31 Jan 2011, 15:49 Delegate Ben said...

Ben has attended:
Excel Intermediate course
Access Introduction course

Access

What happens if I don't my primary key contains non-unique entries?

Tue 1 Feb 2011, 14:04 Trainer Anthony said...

RE: Access

Hi Ben, thanks for your query. By definition a primary key field has to comprise unique identifiers. If it doesn't, when you run a query to return a specific record you will get two conflicting results which is definitely not what you want. If in doubt, just set an ID field to the Autonumber datatype if you need a new primary key field.

Hope this helps,

Anthony

Tue 8 Feb 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips