Hi I have a problem. I have added the new column in some sql table and I need to refresh the table in Access, becouse this new column is not there. How can i do this?
thanks
Ondrej
Hi I have a problem. I have added the new column in some sql table and I need to refresh the table in Access, becouse this new column is not there. How can i do this?
thanks
Ondrej
Go into the Linked Table Manager, select the table and click OK.
Linked table Manager is gray, i can´t click
Last edited by pbaldy; 03-18-2015 at 03:40 PM. Reason: Delete mystery character
How about when you right click on the table in the Nav pane?
I think you might have to delete the link to the SQL table, then use the ODBC Database manager to re-create the link. (working from memory - and it is like a sieve)
I've never had to do that. I just refresh the link in the Linked Table Manager.