Access 2002 vs. 2003

[Neil]

We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.

I've been saying that we need to upgrade to Access 2003, not 2002, even if
Office is kept at 2002. We are also looking to do a fair amount of
redevelopment of our application, and I want to do it in 2003.

Am I right for insisting on Access 2003 over 2002, or is there not that much
of a difference? If there is a significant difference, what can I say in
support of getting licenses for Access 2003?

Thanks!

Neil

[david epsom dot com dot au]

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)
<Gi*************@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr 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.

[George Nicholson]

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.
<Gi*************@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr 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.

[WannaKatana]

Ok it was a dumb question :-)

Is there somewhere to find what the version number of Access would be
after this update?

My mistake was finding the version number that resulted from the
service pack only rather than the update which came subsequent to the
full service pack.

Thanks,

Joel

Douglas J Steele wrote:

What you would appear to be missing is KB904018, as mentioned in the article
to which George pointed you.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
<Gi*************@gmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr 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.