About "Operation must use updateable query" (Error: 3073)

[hoganxian]

Hi,there,

My purpose is once clicking the a button ( using Access form ) VBA
code will generate a query and execute it.

However, I encounter this error: "Operation must use updateable
query" (Error: 3073)

I set "Everyone" has the full control of the Access database folder,
but it does not work.

If I test that query in a module( step by step, without using Form,
Button, etc) it works well.

So, what's the problem?

Any ideas?

thanks~~

 

[SusanV]

What's the query?

 

[hoganxian]

Left join two exist query

What's the query?

 

[SusanV]

The SQL?

Left join two exist query

 

[hoganxian]

SELECT gfkey, german
FROM gfkeys LEFT JOIN Tran
ON strcomp(gfkeys.gfkey,Tran.english,0)=0
WHERE Tran.english is NULL or Tran.german='&NOTRAN&';

B.T.W This SQL is generated by VBA.

 

[SusanV]

VBA DoCmd.RunSQL only executes action queries - update, insert, make table
etc. Not Select. You can use the SQL you generate for a recordset, then use
the recordset to update your table or whatever...

 

[dbahooker]

if you get this message in a real-world implementation-- then run away
and start using Access Data Projects


MDB just randomly craps out


-Aaron

 

[hoganxian]

The problem is : If I run this query in another macro,like this:

public sub test()

DoCmd.TransferSpreadsheet, acExport,
acSpreadSheetTypeExcel9,'qryTemp","d:\a.xls"

end sub

It works very well!!!

So, why??

 

[SusanV]

Macros will run select queries, docmd won't
<shrug>