Using Access97 with sql server 2005 - issues ?

[lesperancer]

currently using access97 to link to sql7 tables
sql7 is running on NT4 and terminal server 2000

in the process of upgrading hardware and software to latest stable
versions
citrix - windows 2003
sql server 2005
office 2003 (maybe 2007)

first step is to implement sql server 2005 on windows 2003 and have it
run with access97 apps on the terminal servers

I assume this means a new sql2005 ODBC driver... will it run on
terminal server 2000 ? windows xp ?

what changes, if any, are required in access97 to use the sql2005 ODBC
driver (other than relinking the tables ) ?

tia

[Tom van Stiphout]

On 15 Feb 2007 13:14:52 -0800, le*********@natpro.com wrote:

No. With an ODBC driver it's just another data source.
-Tom.

>currently using access97 to link to sql7 tables
sql7 is running on NT4 and terminal server 2000

in the process of upgrading hardware and software to latest stable
versions
citrix - windows 2003
sql server 2005
office 2003 (maybe 2007)

first step is to implement sql server 2005 on windows 2003 and have it
run with access97 apps on the terminal servers

I assume this means a new sql2005 ODBC driver... will it run on
terminal server 2000 ? windows xp ?

what changes, if any, are required in access97 to use the sql2005 ODBC
driver (other than relinking the tables ) ?

tia