I can only take a guess at the cause of the error as you have not listed any code that opens the query or explained in which event this is supposed to happen.To resolve this when you open the access table by using Visual Basic code, include the dbSeeChanges option, as in the following example:

Set rs = db.OpenRecordse t("TestTable" , dbOpenDynaset, dbSeeChanges)


The dbSeeChanges option ensures that...

Nice article. Here is one more way so that you can get rid from this error Check your DSN settings and make sure you can connect there. Another thing to check is ownership and permissions on the other tables. Access won't let you link to or display tables you don't have permissions on. Use another tool on that
machine (like Query Analyzer) to test to see if it's a connection
string or permissions problem. Or it may be database corruption...