Can't Open table if query run first.

[SirDrums]

Strange problem.

I have a link table in my DB that seemed to be working fine.

I referenced the table in a query and the query worked fine.

I close and reopen access and run the query and I get a message that access can't fine the link table.

Then when try to open the table directly it gives me the same error about not finding the table.

If I close and reopen access again and open the table before running the query, the table opens fine and the query works properly.

The only difference I can see betwen this link table and the others in the MDB is that it is from a different Datasource (ODBC).

Any ideas?

Thanks!