Link to home
Start Free TrialLog 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
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
found the answer myself