Runing query with VBA getting no records while manually run ok

[muster]

Hi ALL,

I run a bunch of queries in code, this patiqular qry_ABC is a make
table query. I run it ok manually, but if I run it like below in code,
it got no records. Other queries run ok in code.

.... other queries
rs.Open "qry_ABC", CurrentProject.Connection, adOpenDynamic,
adLockOptimistic, adCmdStoredProc
....

Any thoughts?

Thank you,
muster

 

[Douglas J. Steele]

Make Table queries don't create recordsets. (No action query - INSERT INTO,
DELETE, UPDATE - does).

Use the Execute method of the Command object.

 

[muster]

Thanks. In fact all other queries are make table queries and they are
ok. This one also creates the table but gets no records.
Pherhaps anything special for this one is that it is based on a select
query.

Still need help.
Thanks,