Default * in query SQL.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Just converted to Access2003. All new queries created by either dragging
individual column names from tables or double clicking table name and
dragging all column into a query result with a wildcard * in the SQL as a
field name. If I remove it from the SQL, the query works correctly. I
reloaded the software so is this a bug or can it be "turn off"?
 
Tools -> Options -> Tables/Queries -> Output all fields? If this is checked,
it inserts the * automatically into the select statement when using the query
builder.
 
That was the problem. Thank you.

Brian said:
Tools -> Options -> Tables/Queries -> Output all fields? If this is checked,
it inserts the * automatically into the select statement when using the query
builder.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameters, Passthrough UpdateQueries, and SQL 6
Access 2010 append query to SQL is very slow 0
query links to SQL server and mdb table 1
Combine Duplicates in Query 0
Access stripping decimal places in query 1
query sql needed 1
SQL Query 2
SQL query 1

Back
Top