Help! Object Invalid or No Longer Set Error

[bigtbone]

I just converted to Access 2000 from 97 and I can't some queries to run. I get "Object Invalid or No Longer Set" error.

It appears to be a problem with DAO and ADO settings. I'm not sure what I need to do to get it to run in 2000, worked perfectly in 97.

I have a table that is ODBC linked to a sql server and a small table that I created that are joined on one field. I can run a query with each table indivualally , but as soon as I join them, I get the the "Object Invalid or No Longer Set Error."

Thanks in advance for your help.

 

[GingerR]

i see a lot of articles about this on MS Technet. might have to do with the foreign keys. this article is re:an Oracle connection but might work for you too.

http://support.microsoft.com/support/kb/articles/Q243/4/59.ASP

also, just search

http://www.microsoft.com/technet

with that error message you listed above and see all the articles. lots are to do with Acc2000