[AccessD] Where is the PK info stored?

<<Does anyone know where Access hides this PK field info?>>

  It stores it as an index as part of the tabledef.

Jim.
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Wednesday, February 29, 2012 11:11 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Where is the PK info stored?

When I link to a view in SQL Server it stops and asks what field is the PK.
If you go into the 
"table definition" in the database window, that field is set as the PK.
Having a PK is required to 
allow the "table" (linked view) to be editable.  Somehow (not sure yet how)
I have managed to strip 
out that information, and suddently editable things become uneditable.  I
relink the view, telling 
it which field is the PK and it is back editable again.

I am trying to determine how I am mangling this thing but knowing where
Access places this info 
would help me in understanding the issue.

Does anyone know where Access hides this PK field info?

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com