I can't edit data in Access from an Excel linked table

J

Juan Ignacio

I have linked an Excel sheet into Access and I am not able to edit the data I
see.

The Excel worksheet is NOT read-only, off course.
In the Tools/Securitu/Macros menu, the level is low
In the Tools/Security/Permissions I have all the permission for this table
 
K

Ken Snell \(MVP\)

These updates disabled the ability to update linked EXCEL spreadsheets when
you use ACCESS 2002 or ACCESS 2003:

Office XP
KB904018, dated October 18, 2005. See
http://support.microsoft.com/kb/904018

Office 2003
SP2. See http://support.microsoft.com/kb/904953/en-us

This feature has been disabled for legal reasons. Microsoft's own words:
"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." Microsoft lost a legal case
(lawsuit)
involving a person who claimed a patent on the feature.

These changes did not affect ACCESS 2000 or ACCESS 97.
 
Top