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?
Is that just the way it is?
You can also hit F5 while in the database window - this will update the references in the front end
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.
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
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
found the answer myself
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.