I have created a report in MS Access 2010 (Windows Server 2003 Standard Edition). The main report contains eight simple sub-reports which run from queries. There is no code on opening any of the subreports.
The report displays correctly in print preview but when we go to print we get the message Invalid Database Object Reference
. On clicking OK a further message appears saying that the record source does not exist. This happens for each subreport. Once we have clicked past all the messages the report prints without any of the subreport detail. (All the queries run when checked and the subreports print fine when opened as an individual report.)
We then often get the message Object Invalid or no longer set
and all objects vanish from the list of queries tables etc. On closing and reopening the database they all reappear. The connection to the network is still live. The database is split and linked by a drive letter rather than a full server path.
I've tried splitting the report into two so that there are only 4 sub-reports on each one but we still get the same message.
I've also imported everything into a new database in case there was a corruption on the database but still have the same problem.
I've checked the references and there are no missing references listed. Those ticked are listed on the attached document.
I'd really appreciate any help or advice.
Thanks in advance