Running multipe queries from a macro

[MArilyn]

I have a macro set up to run 3 different macros. One is an
append, one is a make table and the last is an update
query. When the macro is run, it seems none of the actions
are taking place. I do not get an error message. When I
run each query stand alone, they run fine. What is my
problem?????

 

[Steve Schapel]

Marilyn,

Do you mean that when you run one of the queries via a macro, it
works, but when you try all three together, none of them works? Can
you give us the details of the macro you are using? Are the queries
quite complex, and therefore take a long time to run?

- Steve Schapel, Microsoft Access MVP

 

[Marilyn]

-----Original Message-----
Marilyn,

Do you mean that when you run one of the queries via a macro, it
works, but when you try all three together, none of them works? Can
you give us the details of the macro you are using? Are the queries
quite complex, and therefore take a long time to run?

- Steve Schapel, Microsoft Access MVP




.
The first query uses ODBC drivers to append to a file. It

has to read 420,000 + records. The next query is a make
table query to add fields to the info from the file
created above for a subset of recirds. The next query is
an update query and the last query is another make table
query using the same table and creating a smaller subset
from it. I hope I have given you enough details?

 

[Marilyn]

-----Original Message-----
It
has to read 420,000 + records. The next query is a make
table query to add fields to the info from the file
created above for a subset of recirds. The next query is
an update query and the last query is another make table
query using the same table and creating a smaller subset
from it. I hope I have given you enough details?
.
This is what my macro look like:

Hourglass
Openquery (vafmd10, design, add)
Close (query, vafmd10, save)
Openquery (tblssnvet, design, add)
Close (query, tblssnvet, save)
Openquery ( )
Close

 

[Steve Schapel]

Marilyn,

Hourglass
Openquery (vafmd10, design, add)
Close (query, vafmd10, save)
Openquery (tblssnvet, design, add)
Close (query, tblssnvet, save)
Openquery ( )
Close

It should be like this...
Hourglass
OpenQuery (vafmd10, datasheet, edit)
OpenQuery (tblssnvet, datasheet, edit)
OpenQuery ( )