On Jul 3, 6:30 pm, Yitzak <terrysha...@yahoo.co.ukwrote:
On 2 Jul, 20:27, "christianlo...@yahoo.com" <christianlo...@yahoo.com>
wrote:
Christian IF I've understood you correctly you try and update the
Access table and expect the underlying Excel sheet to change?
Yes.
Unfortunatley this doesn't work by design, its a security issue and a
Service pack and/or fix for Access disabled this functionality. Cannot
give you a link but have seen it.
In the posted link to the kb article:
-----------
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.
-----------
Count yourself lucky, on one machine I've seen the ISAM error when
using a linked table to update a "normal Access" table i.e. not
changing the linked table. Apparently Jet gets a bit confused and
doesn't realize which table is being updated...
Sounds less like a security issue and more like a feature they just
couldn't implement correctly. Besides, since the kb article says it's
a LEGAL issue m$ probably stole the code from someone else in the
first place (wouldn't be the first time).
FUBAR