I am currently using the SQL Link Server option for the QODBC Connector.  I am using Microsoft SQL Server 2000 with the latest service pack.   I am able to link the database sucessfully, view all the tables and can run the following  query as a view with no problems:

SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM Customer')

This returns all the records in a recordset with fields in the column headers. 

But when I try to query on any other table in the database, for example:

SELECT * FROM OPENQUERY(QODBC, 'SELECT * FROM Invoice')

The recordset returns with no records but does show the fields in the table in the view's column headers.  I verified that there are records in that table using the VBDEMO program.

Any ideas would be appreicated.