I have a SQL Server 7 system and an access 2000 ADP front-end. On my development machine, I have no problems. But on some (if not all) user machines they periodically see, when opening a report: "Error 2580 -The record source 'tbl name' specified on this form or report does not exist."

However the object does exist and has SELECT permissions granted to PUBLIC.

Did you ever resolve this problem. I'm experiencing the same problems with an Access.adp.

Any help would be greatly appreciated

Regards

Tim

is this a temporary table?

This is actually the same query as I've posted in topic 11778, to which you've also responded.

http://p2p.wrox.com/topic.asp?TOPIC_ID=11778

In my case this is a problem with stored procedures

you may try and check the condition of your database and tables

dbcc checkdb
dbcc checktable