Error 3065: Cannot execute a select query.

**CrdiB** · 11-12-2020, 04:20 AM

I am running this code and when running the code, this error msg shows up," Error 3065: Cannot execute a select query. ". it debugs on this line

Please Login or Register  to view this content.

Please help me with this

Please Login or Register  to view this content.

**rorya** · 11-12-2020, 08:39 AM

What would you expect that line to achieve? A SELECT query returns records but you aren't attempting to store the result in a recordset.

**CrdiB** · 11-13-2020, 02:57 AM

how to store ?

**rorya** · 11-13-2020, 05:15 AM

Same way you did it here:

Please Login or Register  to view this content.

You can use SQL strings as well as simple table/view names.

**CrdiB** · 11-13-2020, 05:22 AM

so what will the code become
?

**rorya** · 11-13-2020, 05:46 AM

Please Login or Register  to view this content.

for example.

Re: Error 3065: Cannot execute a select query.