I have an application with front-end Access 2000 and back-end SQL Server.
I am using linked tables through ODBC.
I've created a simple select query(qry1) based on 2 linked tables.
It worked fine on both system(Win 2k and Win NT)
Now if I tried to create another select query based on qry1 and a linked table , on Win2k it runs OK, but on Win NT I've got ODBC fails (error #107)
I am using the last MDAC.
Any suggestion would be much appreciated.
Thx,
Cris
I am using linked tables through ODBC.
I've created a simple select query(qry1) based on 2 linked tables.
It worked fine on both system(Win 2k and Win NT)
Now if I tried to create another select query based on qry1 and a linked table , on Win2k it runs OK, but on Win NT I've got ODBC fails (error #107)
I am using the last MDAC.
Any suggestion would be much appreciated.
Thx,
Cris