Append Queries Help!!

[Andrew]

is their a ny code I could write that would triger 5 append queries to triger
at once: sending this data from a laptop or other computer to a server
database?

 

[Douglas J. Steele]

Access can only run one query at a time, so you'd have to send five separate
commands.

 

[Brian Smith]

Access can only run one query at a time, so you'd have to send five
separate commands.

In an earlier thread posted a few minutes before this one he said he wanted
to do this at the touch of a button. That would be doable via code would it
not by just having the five queries run after one after another and turning
warnings off?

Brian

 

[Gina Whipp]

This was actually the soultion I posted. I didn't see that the post posted
a second time.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Douglas J. Steele]

In an earlier thread posted a few minutes before this one he said he
wanted to do this at the touch of a button. That would be doable via code
would it not by just having the five queries run after one after another
and turning warnings off?

Definitely.

In fact, you could even wrap the five queries into a single transaction so
that either all will work or all will fail.