I have a Problem which I cannot solve at all.
On a customers PC (Win 7 32bit) runs an app in an acc 2010 RT (SP2 already), backend is a SQL Server 2008 Express.
I have a couple of reports which do not work properly.
Before that I have to state that I did everything I know to check my database before deploying it to the RT Environment.
- decompile, compact, checking references, all that stuff...
An accde (ord accdr) did not even start on the customers machine. It Fails with the error
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."
No further error code. Web Research did not help me in any way.
Well, then I tried it with an accdb on the acc RT, it starts, seems to work but the it crashes on reports who have an passthrough query as recordsource.
But not all, only some. The recordsource itself delivers the correct data - I open the PTquery via a button just to chekc if there is any content , but the reports bring no data. Very strange, as others works the same way, but using other PT queries, but have the same construction, that the datasource it the PTquery. No filter, nothing.
I am totaly in despair as there is no pattern of this error. Not only that the Report has no Content (could avoid this by no_data...), I cannot find the reason of that.
it is very very strange and also a check of all the references showed the correct Versions on both machines.
Any ideas is very much appreciated.
Michael
On a customers PC (Win 7 32bit) runs an app in an acc 2010 RT (SP2 already), backend is a SQL Server 2008 Express.
I have a couple of reports which do not work properly.
Before that I have to state that I did everything I know to check my database before deploying it to the RT Environment.
- decompile, compact, checking references, all that stuff...
An accde (ord accdr) did not even start on the customers machine. It Fails with the error
"The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all code from modules, forms and reports. You should back up your database before attempting to open the database and delete the VBA project."
No further error code. Web Research did not help me in any way.
Well, then I tried it with an accdb on the acc RT, it starts, seems to work but the it crashes on reports who have an passthrough query as recordsource.
But not all, only some. The recordsource itself delivers the correct data - I open the PTquery via a button just to chekc if there is any content , but the reports bring no data. Very strange, as others works the same way, but using other PT queries, but have the same construction, that the datasource it the PTquery. No filter, nothing.
I am totaly in despair as there is no pattern of this error. Not only that the Report has no Content (could avoid this by no_data...), I cannot find the reason of that.
it is very very strange and also a check of all the references showed the correct Versions on both machines.
Any ideas is very much appreciated.
Michael