Linked Table Problems

Lost functionality

Have you found that you cannot update linked Excel tables in Access 2003+?


If you have installed Microsoft Office 2003 Service Pack 2 (SP2):

MORE INFORMATION
Because of legal issues, Microsoft has disabled the functionality in Access 2003 and in Access 2002 that let users change the data in linked tables that point to a range in an Excel workbook. However, when you make changes directly in the Excel workbook, the changes appear in the linked table in Access.

Support.Microsft.com:
You cannot change data in tables that are linked to an Excel workbook

You might try reinstalling and then only installing SP1.

Also:

PCWorld.com:
Patent ruling costs Microsoft $8.9 million

"A jury in U.S. federal court found that Microsoft infringed on a Guatemalan inventor's 1994 patent on technology linking the company's Access and Excel programs, and ordered the world's largest software maker to pay $8.9 million in damages.

See all Topics