AccessDiscussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
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
The sql code in query is replaced by "Select *"
Kindly reply and help me to get a solution to this problem.
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?