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.

Have you compacted the database with the tables?

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com

Yes, I did compact the database with the table. Still the query runs for some time then it loses its sql code and I get the error # 3066.
Thanks.

Surajguru,

How big are your tables?
How many columns are there on your table?
Are you running the query from a button or directly?

Kevin

dartcoach

Surajguru,
Sorry about that. I see that you are retrieving 181 columns. I don't know for sure, but you may be running out of memory. 181 columns on a single table is huge! Can you retrieve lesser amounts of data? I.E. - retrieve 60 columns at a time, then join the results together?

Don't know if this might help.

Kevin

dartcoach