[AccessD] Where is the PK info stored?

 Right. The index on the table has a 'Primary' property that is true or false

Here's a sample function that returns *one* primary key field. You'll to modify it for tables with compound primary keys.

Lambert

Function GetPKName(strTable As String) As String
Dim db As DAO.Database
Dim curTbl As TableDef
Dim cntKey As Integer
Dim curIdx As Index
Dim cntIdx As Long
Dim curIdxFld As Field
Dim curFld As Field
Dim cntFlds As Long

    Set db = CurrentDb
    Set curTbl = db.TableDefs(strTable)
    For cntFlds = 0 To curTbl.Fields.Count - 1
        For cntKey = 0 To curTbl.Indexes.Count - 1
            Set curIdx = curTbl.Indexes(cntKey)
            '** Loop though all the fields in the current index
            For cntIdx = 0 To curIdx.Fields.Count - 1
                Set curFld = curTbl.Fields(cntFlds)
                Set curIdxFld = curIdx.Fields(cntIdx)
                '* is the current field part of the primary key?
                If (curFld.Name = curIdxFld.Name) And (curIdx.Primary = True) Then
                    GetPKName = curIdxFld.Name
                End If
            Next cntIdx    ' move to next field in the current index
        Next cntKey    ' move to next index in current table
    Next cntFlds
End Function


-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman
Sent: Wednesday, February 29, 2012 12:47 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [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

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