Front end Access 97 application to access SQL Server
2000(SP2) via ODBC connection. The test of ODBC is
successfully but the Access 97 application is unable
to access the SQL Server database if the MDAC version
is 2.5 or less. There is no problem for those machines
installed with MDAC 2.6 above. Anyone has ideas?
Thanks for your advise.