Here is a strange thing. I have an Access database linked to SQL Server back end. I have several reports that run from queries. On one PC when I open a report in design mode and set the Report Source the drop down list includes the "dbo" part eg dbo.ReportQuery1and the report works fine.

However on another PC the report doesn't work with the error - "Cannot find ReportQuery1" and when I open the report in design mode on this PC the "dbo" is not there - either in the record source or the drop down list! Therefore the report doesn't think the query exists!

The picture shows what I mean. The left hand picture shows the dropdown box on the report without the "dbo" qualifer in the list - on the right is the dropdown with the "dbo" qualifer. The report works on the PC that displays this but not on the other as says it can't find query "dbo.PRACTICE" - because in its list it is just "PRACTICE".


Does anyone have any ideas at all???


Thanks

Open the MSysObjects table in the database with the problem. Check to see if the table was renamed when it was linked.

sysobjects table is OK so that isn't it but thanks for replying.

I have worked round it by ensuring all reports are saved in the one showing the "dbo" and then not going in to design mode on the other, which seems to wipe the settings.

Don't know what has caused it - wonder if it is a service pack bug.

I've never seen it or heard of it. Perhaps the othe copy is corrupted. Try recreating it.