By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,827 Members | 2,155 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,827 IT Pros & Developers. It's quick & easy.

Access/Excel Linked Table Will Not Update

P: n/a
I've linked an excel worksheet as an access table. The values appear
but it won't allow me to change any of the values.

To test I've provided a fresh blank workbook and same problem.

I've done this on other computers and it's worked fine.

Using:
Win 2000 SP4

Jul 2 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Hi
I've linked an excel worksheet as an access table. The values appear
but it won't allow me to change any of the values.

To test I've provided a fresh blank workbook and same problem.

I've done this on other computers and it's worked fine.
Guess there are different versions ore service packs installed.

Take a look at this KB-article :

http://support.microsoft.com/?kbid=904953

Regards
Jens
Jul 3 '07 #2

P: n/a
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?

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.

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...
Jul 3 '07 #3

P: n/a
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

Jul 5 '07 #4

P: n/a
"ch************@yahoo.com" <ch************@yahoo.comwrote in
news:11**********************@g4g2000hsf.googlegro ups.com:
On Jul 3, 6:30 pm, Yitzak <terrysha...@yahoo.co.ukwrote:
>On 2 Jul, 20:27, "christianlo...@yahoo.com"
<christianlo...@yahoo.comwrote:

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
It's not a security issue at all. It's a (Expletive deleted)
copyright/ issue.
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Jul 5 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.