Error running MS-ACCESS Queries using C/ODBC

Hi All I’m trying to run MS Access queries against our Native 2.6b database using C/ODBC but nothing is working. I keep getting this error : [Navision Software a/s][Navision Financials ODBC driver]Assignment error (#1012) Any ideas?

Error 1012 is usually a rights error. Sorry I can’t be of more help.

I’ve recreated the link tables in Access and it seems to work now. But I get this other error : ISAM error #4 ? Is this a rights error also?

Sebastien, this is an entirely different error. It is usually a pathing issue, Access is looking for an ISAM driver and can’t find it. Access 97 used ISAM drivers, newer versions do not. Try to find the driver and copy it to your C/ODBC directory. The Microsoft knowledge base article listed below may be of some help to you: http://support.microsoft.com/default.aspx?scid=kb;[LN];209805