16 bit odbc errors

[Trevor]

We are in the process of upgrading some of our servers to SQL Server 7.0.
The problem is that we have a number of 16 bit applications (Access 2.0) that we are slowly trying to rewrite but we just aren't there yet. I have a test server setup but I cannot access any of the databases with any of the 16 bit applications. I get a permissions error however, the permissions seem fine. Is there a step I am missing that will get these working until we can rewrite the rest?

Thank-you in advance.

[Paul]

Access 2 i've not ised with SQL Server but coiuldn't you upgrade the Access 2 DBs to Access 7 or 8 and link the SQL tables to that ??

------------
Trevor at 3/5/01 10:45:15 AM


We are in the process of upgrading some of our servers to SQL Server 7.0.
The problem is that we have a number of 16 bit applications (Access 2.0) that we are slowly trying to rewrite but we just aren't there yet. I have a test server setup but I cannot access any of the databases with any of the 16 bit applications. I get a permissions error however, the permissions seem fine. Is there a step I am missing that will get these working until we can rewrite the rest?

Thank-you in advance.