I am using SQL server 2000 and have successfully created a linked server to an Access 2007 database. By successful I mean I can expand the linked server and see the tables. However, when I run a simple select from one of the tables, I get the following error:
OLE DB provider 'Microsoft.ACE.OLEDB.12.0' returned an invalid schema definition.
My code is: SELECT * FROM RMAData...RMA
Is there a problem with SQL Server 2000 and Access 2007 playing nice? Is there something else I need to specify in my connection? The permissions are all setup in the linked server connection.