>Thank you for your response. I think that you did read me correctly. I tried inserting your code snippet into my function, and it still gives me that dialog box. My code goes through each table in the dbc, and checks it. On error 114 (the index file does not match the table) I 'fix it' by modifying the dbc, deleting the cdx, open the table (to index it), etc. I inserted the code where I am attempting to open the table, and I still get that dialog box. Do you have any idea what I may be doing wrong?
>
The best solution here is to purchase and use Stonefield Database Toolkit, which is an add-on that maintains information about table, database, index and view construction in a separate set of tables, It can be set up to check the integrity of various elements of your database at startup, and if necessary update or recreate them.
www.stonefield.com