We are using an Access Data Project client with a SQL Server 2000 back-end. We have created several reports that contain sub-reports. We've found that when we go to export or email them, a message will pop up telling us "Microsoft can not find the object ..." with the data source of the sub-report named as the object. The sub-reports will be based off of a view or stored procedure and it doesn't seem to matter which type is used. The same thing happens when we try to email the reports. The funny thing is, if after getting the message, you can close the report and re-open it up again, and it will then allow you to export or email it. We've tried several different methods to find a solution as to why it does this, but we are at a loss. Has anyone had anything similar occur? If so, how did you resolve the problem or is there no solution? Any ideas would be much appreciated. Thanks.



Aaron

Hello,

Sounds like a glitch to me, are there available updates for Access on Office Updates that might fix this? Don't know myself for sure. Also, SQL Server has a reporting tool also that you can use if you want to get away from Access.

Brian