Hi all,
I have recently moved my databases on a new MSSQL 2000 server. Previously it was on MSSQL 7.0. After the import process, I could no more connect on the new server from access. I have recreate a new Data Sources in User DSN according to the new server and the test was OK. I have checked all the permissions on the databases for the access user. The errors are Server Error 0, 1703 and 11.
Any help would be appreciated....
I have recently moved my databases on a new MSSQL 2000 server. Previously it was on MSSQL 7.0. After the import process, I could no more connect on the new server from access. I have recreate a new Data Sources in User DSN according to the new server and the test was OK. I have checked all the permissions on the databases for the access user. The errors are Server Error 0, 1703 and 11.
Any help would be appreciated....