Access 97 and Win XP 64-bit

[mjt7email-ggroups]

Hello Everyone

Is anyone using (or have you used) Access 97 under Win XP 64-bit OS?

If so, are there any issues, particularly in a multi user environment
where some users will be upgraded to XP 64-bit, while most stay with
XP 32-bit?

MS state "The 2007 Microsoft Office system programs client is a 32-bit
application and can run on a Windows 64-bit platform (Windows XP,
Windows Server 2003, and Windows Vista) but there may be some feature
limitations as noted in the system requirements below." (http://
office.microsoft.com/en-us/products/ha101668651033.aspx)

But I wonder about Access 97…

Thank you for any help,
Marguerite

 

[david]

Whatever problems there might be, they won't relate to multi-user,
because Windows network connections are 32/64 bit agnostic: the
network connections look the same if they are looking at a 32 bit
server or at a 64 bit server. The multi-user bits are all standard
network bits, so they are 32/64 bit agnostic as well.

(david)

Hello Everyone

Is anyone using (or have you used) Access 97 under Win XP 64-bit OS?

If so, are there any issues, particularly in a multi user environment
where some users will be upgraded to XP 64-bit, while most stay with
XP 32-bit?

MS state "The 2007 Microsoft Office system programs client is a 32-bit
application and can run on a Windows 64-bit platform (Windows XP,
Windows Server 2003, and Windows Vista) but there may be some feature
limitations as noted in the system requirements below." (http://
office.microsoft.com/en-us/products/ha101668651033.aspx)

But I wonder about Access 97…

Thank you for any help,
Marguerite

 

[mjt7email-ggroups]

Hello David

Many thanks for the info. I understand the gist but not fully, however
the IT manager is watching the thread and I'm sure he will.

I've found info relating to Access 97 and Vista but nothing specific
to XP 64-bit. I'm hoping that since no-one is shouting that 97
*doesn't* work with 64-bit then all is OK<s>.

Regards
Marguerite

 

[Guest]

You may have noticed discussion about 64 bit ODBC.

If ODBC is required (for linked tables to SQL Server),
Access uses the 32 bit ODBC API The 32 bit ODBC
API requires 32 bit ODBC drivers, which require the 32
bit ODBC framework. I think that I have seen that it can
be installed on 64 bit Windows XP, but it is not standard.
ODBC is not required for Access MDB or excel or text
links, and I don't think that it is required for xBase linked
tables when using Access 97, but it is required for using
SQL Server linked tables.

Access 97 uses a different installation package than Access
2000-2007 use, and requires admin login to install on
Windows XP (32 or 64). It also requires admin login
to change between Access 97 and a different version.

Access 97 Service pack 3 must be installed if your
target PC has 1GB memory or more (32 or 64), and
should be installed anyway.

I don't know how printers work on XP64, but I guess
that if Office 2007 can work, A97 shouldn't have any problems.

(david)




Hello David

Many thanks for the info. I understand the gist but not fully, however
the IT manager is watching the thread and I'm sure he will.

I've found info relating to Access 97 and Vista but nothing specific
to XP 64-bit. I'm hoping that since no-one is shouting that 97
*doesn't* work with 64-bit then all is OK<s>.

Regards
Marguerite

 

[mjt7email-ggroups]

Hello David

I know that Access 97 SR2 is installed on all PC's. I checked today
but couldn't find an SP3 for Access - do you mean Jet 35 SP3?
http://support.microsoft.com/default.aspx?scid=KB;en-us;172733

The IT mgr told me ages ago that some of the PC's have 1GB memory so
they must already have Jet SP3 (I work from home and can't check for
myself), and ODBC doesn't apply.

Thank you for your help, regards
Marguerite