Can't find source query...error running Access 2003 file with Access 2007

[Wes Montgomery]

I have a Access 2003 application being run under a Access 2007 unbrella.
The application runs fine from the Administrators machine but none of the
users can run the application. All client including the Admin are using
Access 2007 to run the Access 2003 file. An error stating: "Can't find
source query." displays, for the users. Can anyone provide any tips on
trouble shooting this issue?

Regards,

Wes.

 

[Arvin Meyer MVP]

Open the form or report that the error is occurring in the Design View. Look
at the Recordsource property in the property sheet. Make sure that the table
or query it names is there.

 

[Wes Montgomery]

Thanks, I don't have the access application at the moment to check the
property, but will. Why would the Recordsource property be different on the
users machine as apposed to being properly set on the Administrators
machine? It's an access 2003 front end, opened with access 2007 hitting an
SQL database. Could it be a rights issue in SQL server not allowing the user
to access it?


Thanks very much.

Wes.

 

[Arvin Meyer MVP]

Yes, it could be a permissions issue.

If a user created a filter, they change the recordsource and are often
saved. In addition to the recordsource property, check the filter and order
by properties, and the Server Filter property.