Link to home
Create AccountLog in
Avatar of avoorheis
avoorheis

asked on

Missing fields in sql server linked tables

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?
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

<<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? >>

  Way it is.  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).

JimD.
You can also hit F5 while in the database window - this will update the references in the front end
Avatar of avoorheis
avoorheis

ASKER

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.
<<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. >>

  I just re-read your question given your response and see that I missed the point of the question.

  I can't understand why that would be the case, even with read-only on the tables.  I would try deleting the link and re-linking and see if the PK field shows up.

JimD.
ASKER CERTIFIED SOLUTION
Avatar of avoorheis
avoorheis

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
found the answer myself