No AutoNumber in ADP tables?

[Guest]

There seems to be no equivalent to the MDP column setting AutoNumber in
Access Projects. But, Access gets cranky if I try to design a table without
a primary key. How do I get around this?

 

['69 Camaro]

Hi, Allen.

There seems to be no equivalent to the MDP column setting AutoNumber in
Access Projects.

It's called an Identity column in SQL Server. For more information on
Identity columns, check the BOL.

But, Access gets cranky if I try to design a table without
a primary key. How do I get around this?

The natural key can be used as the primary key, even if the natural key is a
composite key, not a single column. Many database developers have never
used surrogate keys in their lives, and they build efficient, effective
databases.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.