Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error Access query on SQL linked table
I'm having trouble getting a query to work while linked to MS SQL Server 7.0 tables from MS Access 2000. I get an "ODBC -- Call Failed" after I'm prompted for the Parameters. Could it be that the evaluation of the 'between' statements in the WHERE clause are not be evaluated properly...- cwy
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Access Query problem
I'm having trouble getting a query to work while linked to MS SQL Server 7.0 tables from MS Access 2000. I get an "ODBC -- Call Failed" after I'm prompted for the Parameters. Could it be that the evaluation of the 'between' statements in the WHERE clause are not be evaluated properly...
