By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,488 Members | 2,552 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,488 IT Pros & Developers. It's quick & easy.

Using Access97 with sql server 2005 - issues ?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.