Help - Query must have at least one destination field

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

Guest

Hello,
I have a table with 181 fields and I have the following select query:
"Select * from Table1 where [Field1]=[Please enter 1: ] and [Field2]=[Please
enter 2];"
This query works fine for sometime and then it gives the following error
message:
"Error # 3066 and Error description: Query must have at least one
destination field."
The sql code in query is replaced by "Select *"
Kindly reply and help me to get a solution to this problem.
Thanks,
Suraj.
 
Hello,
I have a table with 181 fields and I have the following select query:
"Select * from Table1 where [Field1]=[Please enter 1: ] and [Field2]=[Please
enter 2];"
This query works fine for sometime and then it gives the following error
message:
"Error # 3066 and Error description: Query must have at least one
destination field."
The sql code in query is replaced by "Select *"
Kindly reply and help me to get a solution to this problem.
Thanks,
Suraj.
Click to expand...

Something (or someone) is overwriting and destroying the query. Your
database may be becoming corrupt: see

http://www.granite.ab.ca/access/corruptmdbs.htm

for symptoms and solutions.

John W. Vinson[MVP]
 
Thanks John, I saw the web site and it has good links.

John Vinson said:
Hello,
I have a table with 181 fields and I have the following select query:
"Select * from Table1 where [Field1]=[Please enter 1: ] and [Field2]=[Please
enter 2];"
This query works fine for sometime and then it gives the following error
message:
"Error # 3066 and Error description: Query must have at least one
destination field."
The sql code in query is replaced by "Select *"
Kindly reply and help me to get a solution to this problem.
Thanks,
Suraj.
Click to expand...

Something (or someone) is overwriting and destroying the query. Your
database may be becoming corrupt: see

http://www.granite.ab.ca/access/corruptmdbs.htm

for symptoms and solutions.

John W. Vinson[MVP]
Click to expand...
 
Back
Top