I have a low-tech client with Access 97. I have a series of update SQL
statements I would like to send to them. In other RDBMS I can run a
series of SQL statements in one go: copy and paste to a query window,
highlight and run. In access 97, it won't allow me to have a series of
SQL statements in one query window.

The number of update SQLs are about 20 in total, so i would be willing
to code it into a script of some kind but i'm not sure how that would
cater for me to transfer that to their copy of the database.

My background is asp and web-based databases, i haven't really touched
upon customising access and using VBA.

Any assistance would be gratefully received,
Andy B

The simplest way to accomplish this without having to learn VBA would be to
use a macro. Within the macro, you can use the RunSQL action for SQL
statements of up to 256 characters. Alternatively, you can save each UPDATE
statement as a query and then create a macro that runs the queries (using
the OpenQuery action).


--
Allan Thompson
APT Associates/ FieldScope LLC
MS Office Automation / Measurement and Reporting Systems
www.fieldscope.com
860.242.4184

"Andy B" <coastalrocket (AT) yahoo (DOT) co.uk> wrote

Thanks Allan, that's the ticket.

"Allan Thompson" <athompson (AT) fieldscope (DOT) com> wrote