How to update table design changes from SQL Server in Access

[Seth Schrock]

I think that this belongs in the Access topic, but this might be more of a SQL Server question.

Anyway, I have an Access 2010 database that is linked to tables in SQL Server 2005. I have noticed that when I make design changes to the table, it doesn't get updated in Access. I have tried closing and reopening Access, but that didn't work either. Is there a way to have the tables update without deleting the link and then relinking them?

[zmbd]

You should be able to just re-fresh the links.

[Seth Schrock]

I had forgotten about that option. It worked perfectly. Thanks Z.

[zmbd]

You can do this via vba too... basically it's the relinker code without the reconnection.

[Seth Schrock]

It probably wouldn't be a bad idea to refresh the link when the database opens so that when I push this out to my users (who run Access Runtime) and there is a network outage, they can just close out and get back in and have the links refreshed.