Query Returns all Values ?

[jpro]

We have one user that gets all records returned from a table everytime a query is run even though there is specific values or even No values at all selected.

We have completely uninstalled Access and reinstalled and there is no difference. Other users can query against this same db without issue.

Anybody ever heard of or delt with anything like this?

Thanks.

Great minds discuss "Ideas"
Average minds discuss "Events"
Below Average minds discuss "People

 

[lameid]

Sounds like

1) you are using something other than Access (JET) to store your data and it has a specific query that limits by something

Or

2) your user has a different copy of the Front End (access file on the local computer that does not contain data but other objects)

In the case of 1, knowing what it is will help. For 2, copying the current version if the file should help.

I'm guessing your problem is related to 2. It could also be a version of JET difference (patch everything).

Seeing the SQL of the query may help us as well.

 

[jpro]

Found an article to solve the issue:

You may receive a "Cannot group on fields selected with '*'" error message when you run a query in Access

SYMPTOMS
When you run a query in a Microsoft Access database that uses one of the aggregate (totals) functions such as the Sum() aggregate function, the Min() aggregate function, or the Max() aggregate function, the query may not run successfully. You may receive the following error message:

Cannot group on fields selected with '*'.

Back to the top
CAUSE
This problem occurs when you use one of the aggregate (totals) functions in your query, and you do not set the Output All Fields query property to No. When you set the Output All Fields query property to Yes, an asterisk (*) wildcard character that represents all columns of the database table is added to the select clause of the Access query. However, you cannot have an asterisk (*) wildcard character together with an aggregate function in the select clause of the Access query. Therefore, when you run the Access query, you may receive the error message that is mentioned in the "Symptoms" section.

Back to the top
RESOLUTION
To resolve this problem, set the Output All Fields query property to No and then run the Access query that uses one of the aggregate (totals) functions. To do this, follow these steps:

1. Start Access.
2. Open the Access database that contains the problem query.
3. In the Database window, click Queries under the Objects section.
4. In the right pane, right-click the problem query, and then click Design View.
5. Click anywhere in the Query window outside the query grid and outside the field lists.
6. On the View menu, click Properties.
7. In the Query Properties dialog box, set the value of the Output All Fields query property to No.
8. On the Query menu, click Run.


Great minds discuss "Ideas"
Average minds discuss "Events"
Below Average minds discuss "People