Convert MS-SQL 2K to SQL 2005

[MN]

Hi-May be this is a stupid question but I don't know. Please advise:
I am using MS Access 2K connect ODBC with SQL Server 2000. Now my company
want to update server to SQL 2005.Question: Do I need to re-write the code
for my application?
Thanks you for all reply
NM

 

[John Spencer]

No, that should not be a problem.

You will need to relink to the new server and the new fields.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[MN]

Thanks John

No, that should not be a problem.

You will need to relink to the new server and the new fields.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Tony Toews [MVP]]

Hi-May be this is a stupid question but I don't know. Please advise:
I am using MS Access 2K connect ODBC with SQL Server 2000. Now my company
want to update server to SQL 2005.Question: Do I need to re-write the code
for my application?

Note that, as with any software upgrade there may be little
differences you may encounter. Testing your app on the new system
would be a good idea.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/