Hi. My Access DB contains 6 make table queries. I use these to create/overwrite tables to a different access DB. The different DB is stored on a shared network folder which is based at a different office, so every time I run one of these make table queries it has to go through the internet.
Also, every time I run a query I get 3 warning messages.
One asking me if I'm sure I want to run it.
Another telling me the existing table will be deleted, should I continue
And a final one telling me I'm about to post X rows into a new table.
Is there anyway for me to click a button and Access run all 6 of these make table queries and to auto confirm all the above mentioned warning messages.
Also, every time I run a query I get 3 warning messages.
One asking me if I'm sure I want to run it.
Another telling me the existing table will be deleted, should I continue
And a final one telling me I'm about to post X rows into a new table.
Is there anyway for me to click a button and Access run all 6 of these make table queries and to auto confirm all the above mentioned warning messages.