ADP / MSDE 2000 Table Creation

R

RHamilton

I'm attempting to create a table in an ADP w/MSDE 2000 and find that data
entry is allowed only after some field is designated as the primary key.
Does MSDE 2000 require a primary key be assigned in all tables? I'm new to
MSDE 2000. Thanks in advance for your help.
 
J

John Vinson

Does MSDE 2000 require a primary key be assigned in all tables?
Click to expand...

Only if you want to edit data in the table from Access or from an ASP
page... in other words, pretty much "yes".

John W. Vinson[MVP]
 
R

RHamilton

Good to know..... Thanks again!

John Vinson said:
Only if you want to edit data in the table from Access or from an ASP
page... in other words, pretty much "yes".

John W. Vinson[MVP]
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

same field in more than one table 2
ADP connection to MSDE 2
Connecting to Sql 0
referential integrity and tables 4
SQL Server 2000 Reference Recommendation Request 0
ADP vs. MDB? 16
Do I have to set the primary key to include primary key fields? 3
Access Runtime .adp To MSDE? 5

Top