How to automate testing procedures?

[Siegfried Heintze]

I apologize if this appears twice. I thought I posted it yesterday and now I
don't see it so I'll enumerate my questions again.

I would like to automate some testing procedures. How may I write a cmd.exe
script to
(1) create an emtpy MSAccess database
(2) populate the database with XML
(3) add users

Thanks,
Siegfried

 

[Smartin]

I apologize if this appears twice. I thought I posted it yesterday and now I
don't see it so I'll enumerate my questions again.

I would like to automate some testing procedures. How may I write a cmd.exe
script to
(1) create an emtpy MSAccess database
(2) populate the database with XML
(3) add users

Thanks,
Siegfried

There are probably more elegant ways, but with my limited knowledge, I
would..

Create a prototype Access DB first. Include in it macros that handle
(2) and (3). Additionally, the macros may need table templates, import
specs, helper queries, etc. to massage and import the data so build
those too.

Call Access from the command file using the /X switch to fire the
macros.

Hoping this helps....