Linked ODBC Trouble

  • Thread starter Thread starter JB_96RS
  • Start date Start date
J

JB_96RS

I have a table in Accesss that is linked to a SQL table. When I add a
new column to the table on the SQL side and then view the table in
Access it does not show my new column. Any ideas?

Thanks
 
JB_96RS said:
I have a table in Accesss that is linked to a SQL table. When I add a
new column to the table on the SQL side and then view the table in
Access it does not show my new column. Any ideas?
Click to expand...

You have to refresh the link any time you make changes on the back end.
Use the Linked Table Manager or else delete the link and recreate it.
 
Back
Top