To my surprise and chagrin, newer versions of Access have disabled the
functionality that lets users change the data in linked tables that point to
a range in an Excel workbook. This is "because of legal issues..." according
to Office Support.

I have other issues, specifically a couple of applications that do things
such as calculate price updates in Access and read them back by means of
update queries into the spreadsheets our marketing people prefer. These
things are simple stand-alone applications and have been working without
hassle for years. Now, as we upgrade our corporate software, they're
suddenly defunct.

I hope someone in this group has tripped over this issue before me and come
up with a workaround they would be generous enough to share.

Also, I'd be interested to know what else I might expect to blow up as we
migrate from Office 2000 to Office 2003.

For a while I thought that was a good idea.

Thanks in advance,

Jim Salmon

This inability to update linked EXCEL spreadsheets is a new thing for ACCESS
2002 and 2003, based on a decision in a court case.

The only workarounds are

1) import the data, modify the data in ACCESS, and then export the data
back to EXCEL;

or

2) use Automation to open the EXCEL spreadsheet and write the changes
directly into the spreadsheet.

--

Ken Snell
<MS ACCESS MVP>



"Jim S" <jimary (AT) enter (DOT) net> wrote