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.

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Wes Montgomery" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
>
> "Wes Montgomery" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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.
>>
>
>

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Wes Montgomery" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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.
>> --
>> Arvin Meyer, MCP, MVP
>> http://www.datastrat.com
>> http://www.mvps.org/access
>> http://www.accessmvp.com
>>
>>
>> "Wes Montgomery" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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.
>>>
>>
>>
>
>