469,275 Members | 1,446 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

Using Access97 with sql server 2005 - issues ?

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

Feb 15 '07 #1
1 1771
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
Feb 16 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Chris Dugan | last post: by
reply views Thread by Bob Hynes | last post: by
3 posts views Thread by Michael Hoehne | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.