skip to content »

Microsoft access linked tables not updating

Cause: After migrating data, hyperlinks in columns lose their functionality and become simple nvarchar(max) columns. Cause: If you later update your SQL Server or SQL Azure tables to contain data types that are not supported by Access, you cannot open the table in Access.

Resolution: Run the following Visual Basic for Applications (VBA) code before accessing the identity field: Cause: When you add a record to a SQL Server or SQL Azure table by using VBA, if the table's unique index field has a default value and you do not assign a value to that field, the new record does not appear until you reopen the table in SQL Server or SQL Azure.Migrating Access Databases to SQL Server Note The feedback system for this content will be changing soon. If content within a comment thread is important to you, please save a copy.For more information on the upcoming change, we invite you to read our blog post.In Access, the tables appear with a "linked" icon, which is a globe with an arrow pointing to it.When you open a table in Access, the data is retrieved using a keyset cursor.If you want to use your existing Access applications with SQL Server, you can link your original Access tables to the migrated SQL Server or SQL Azure tables.

Linking modifies your Access database so that your queries, forms, reports, and data access pages use the data in the SQL Server or SQL Azure database instead of the data in your Access database.

Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Print "Refreshed ODBC table " & originalname Next i Set db = Nothing End Sub Thank you for your interest in this question.

Note Your Access tables remain in Access, but are not updated together with SQL Server or SQL Azure updates.

After you link the tables and verify functionality, you might want to delete your Access tables.

Is there a way to relink these linked server tables without restarting Access?