Runing query with VBA getting no records while manually run ok

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

muster - 29 Mar 2007 16:55 GMT

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

Reply to this Message

Douglas J. Steele - 29 Mar 2007 17:06 GMT

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

Use the Execute method of the Command object.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi ALL,
>
[quoted text clipped - 11 lines]
> Thank you,
> muster

Reply to this Message

muster - 29 Mar 2007 18:32 GMT

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,

On Mar 29, 12:06 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:

> Make Table queries don't create recordsets. (No action query - INSERT INTO,
> DELETE, UPDATE - does).
[quoted text clipped - 22 lines]
>
> - Show quoted text -

Reply to this Message