Access 2002 vs. 2003

Thank you for posting this: I've been wondering if my
experience was atypical.

For my benefit, could you confirm what you are seeing
by looking in the registry (use Run, Regedit) at

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Excel

Originally, my PC showed the Win32 value
c:\windows\system32\MSexcl40.dll

Later, this was changed to
C:\program files\Office11\msaexp30.dll

(david)


wrote in message
oups.com...
I have been asked about this at work. I'm a little confused. Some
places say that only linking to an excel spreadsheet causes the
problem, but elsewhere it says specially linked to a named range in an
spreadsheet.

My Access version is SP3, Version 10.6501.6626. I created an excel
spreadsheet with a named range, linked to it from Access 2002 (Access
2000 file format) and was able to update the information in the named
range no problem.

What am I missing I wonder?

Joel


George Nicholson wrote:
.....Access cannot write to Excel?
Is a gross overstatement. It only involves the updating of spreadsheets
that
are set up as linked tables within Access, and even then the limitation
is
one-way.

http://support.microsoft.com/kb/904953/

Describes the issues and workarounds.

"...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....."

Article includes links to:
http://support.microsoft.com/kb/887616/ Office 2003 SP2 (released Sep 27
2005)
http://support.microsoft.com/kb/904018/ Access 2002/XP update (dated Oct
18
2005)

Anyone with Automatic Updates activated has been living with this for
several months.

HTH,
--
George Nicholson

Remove 'Junk' from return address.

From within Access, you changed the linked data and those changes were also
automatically reflected in the Excel file? AFAIK, that, and only that, is
what the "update" is supposed to disable.

Some places say that only linking to an excel spreadsheet causes the
problem, but elsewhere it says specially linked to a named range in an
spreadsheet.

I assume that the link-to-an-excel file element is all that matters, but I
don't know that for a fact. I believe that the "named range" references
you've seen (I've seen them too) were in "how-to" workarounds of a specific
problem (i.e., "...you used a named range..."), but the possible problems
users might run into are not limited to that.

HTH,
--
George Nicholson

Remove 'Junk' from return address.


wrote in message
oups.com...
I have been asked about this at work. I'm a little confused. Some
places say that only linking to an excel spreadsheet causes the
problem, but elsewhere it says specially linked to a named range in an
spreadsheet.

My Access version is SP3, Version 10.6501.6626. I created an excel
spreadsheet with a named range, linked to it from Access 2002 (Access
2000 file format) and was able to update the information in the named
range no problem.

What am I missing I wonder?

Joel


George Nicholson wrote:
.....Access cannot write to Excel?
Is a gross overstatement. It only involves the updating of spreadsheets
that
are set up as linked tables within Access, and even then the limitation
is
one-way.

http://support.microsoft.com/kb/904953/

Describes the issues and workarounds.

"...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....."

Article includes links to:
http://support.microsoft.com/kb/887616/ Office 2003 SP2 (released Sep 27
2005)
http://support.microsoft.com/kb/904018/ Access 2002/XP update (dated Oct
18
2005)

Anyone with Automatic Updates activated has been living with this for
several months.

HTH,
--
George Nicholson

Remove 'Junk' from return address.