<div>
&lt;&lt;Guess I've never needed the fields that are missing. Seems that they are all keys or indexes. The account, through which the connection is made is read only.<br />
Is that just the way it is? &gt;&gt;<br />
<br />
&nbsp; Way it is. &nbsp;You won't see design changes on the SQL side until you either delete and re-link the table or refresh the existing table link (use linked table manager under database/tools or do it in code).<br />
<br />
JimD.
</div>


<div>
You can also hit F5 while in the database window - this will update the references in the front end
</div>


<div>
hmmm, there hasn't been any changes on the sql side since I've linked the table. It's that the primary key is just not showing at all in the linked table.
</div>


<div>
&lt;&lt;hmmm, there hasn't been any changes on the sql side since I've linked the table. It's that the primary key is just not showing at all in the linked table. &gt;&gt;<br />
<br />
&nbsp; I just re-read your question given your response and see that I missed the point of the question.<br />
<br />
&nbsp; I can't understand why that would be the case, even with read-only on the tables. &nbsp;I would try deleting the link and re-linking and see if the PK field shows up.<br />
<br />
JimD.
</div>


<div>
<div class="content wysiwyg-content">
Guess I've never needed the fields that are missing. Seems that they are all keys or indexes. The account, through which the connection is made is read only.<br />
Is that just the way it is?
</div>
</div>


Guess I've never needed the fields that are missing. Seems that they are all keys or indexes. The account, through which the connection is made is read only.
Is that just the way it is?

Missing fields in sql server linked tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.