ODBC link

[Jacob Mathai]

I use Windows XP and ACCESS 2007. We have ODBC link to an SQL server.
Will there be any problem with current ODBC link when we upgrade to Windows 2007?

 

[Banana]

Usually, no. One oft reported mentioned issue was that there would be a problem with driver but usually was changing to the other driver.

For example, if the ODBC linked tables uses say, "SQL Server Driver", and has problems, changing driver to 'SQL Native Client" fixes this.

HTH.

 

[Jacob Mathai]

I have the link in a Macro.

DataBase Name ODBC;DRIVER={SQL Server};SERVER=XXX.YYYY


Thanks for the Reply.