Query shows all the records of the tables without even selection

  • Thread starter Thread starter Mishanya
  • Start date Start date
M

Mishanya

Whenever I create a new query with Design View and add table/s, the output
shows all the fields of all the table/s, even though no fields are selected
into the grid.
The SQL statment is

SELECT *
FROM tblName;

S I have to choose the wanted fields and then to delete " *, " from the end
of the SQL statment in order to get only the needed selection.

Is it some cind of corruption?
 
Right click in the area where you put your tables, choose disply and fields,
and change to no.
 
OK, Got it, thanks.
I can't recall doing anything to change this option to YES. Is there anyway
to make this option NO permanently?
 
For ACCESS 2003 and earlier:

Tools | Options | Tables/Queries

Uncheck the box "Output all fields"
 
golfinray and Ken.
Thank U very much!

Ken Snell (MVP) said:
For ACCESS 2003 and earlier:

Tools | Options | Tables/Queries

Uncheck the box "Output all fields"
Click to expand...
 
Back
Top