Some target machines say recordsource not found in reports, workselsewhere...

[Joe]

Hello,

We have a set of 4 ADP projects that comprise a data entry and reporting
application to be deployed at our customer site.

On multiple test machines here, these project work flawlessly, the
reports work fast, etc. No problems, with various configurations.

At the client site several machines will not run reports. They display
an error message that the record source could not be found, even though
it exists.

Has anyone else encountered this issue? Any suggestions as to what
might be causing the problem?

The client computer configuration is as follows:

MS Office 97 installed w/ Access 97 for UA Accounting
MS Office 2000 Premium Edition installed
MS Outlook 2003 installed

MS Access XP Runtime installed for the ADP files.

For various reasons the client insists on having multiple versions of
Office installed. We constructed a test machine in similar
configuration and were not able to reproduce any errors. However, on
our test machine, we made sure to install each version of Office into a
separate folder i.e. C:\Program Files\Microsoft Office 97, C:\Program
Files\Microsoft Office 2000, etc.

Thanks,

Joe

 

[Sylvain Lafontaine]

Some of the dbo. prefix must be missing in the various source definitions in
your ADP projects or your stored procedures on the target SQL Server have
been created under a different user account. In the later case, you must
use the correct prefix.

This is a recurrent problem with ADP.

S. L.