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

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 wrote:
> 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

Thanks John :-)

"John Spencer" wrote:

> 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 wrote:
> > 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
>

MN <(E-Mail Removed)> wrote:

>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/