[ODBC Microsoft Access Driver] Index not found

[RTorrance]

I have an Excel spreadsheet that has a query init that links to an Access Database. When I go to edit the query I get this error: [ODBC Microsoft Access Driver] Index not found. I'm not sure if this error has to do with ODBC drivers or possibly an index on a table. All of the indexes seem to be fine and i have reinstalled MDAC 2.8 and Jet. Any help would be appreciated. Thanks
Rachael

 

[Cagliostro]

I believe this is a problem like you try to use a column name which does not exist in the access db:

access db table
xxx
col1
colHello
colGoodBye

and in excel you try to find some columX which does not exist in the database. Also it could be when you access column by index and use 1. some index 0 but indexes begin from 1, 2. some index n but indexes ends with n - 1

Ion Filipski

 

[ETID]

Another cause could be a prompt parameter in an access query...if this is the case, move the prompt to msquery.