Access 97 updates 1

[SQLScholar]

HELp.

I have a load of updates to do (separate commands).

Seems that Access can only do one at a time.

What i was thinking.....

If i uploaded the updates into a table, is there any easy way to cylce through and run each one via a module?

TIA

Dan

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[PWise]

create a table with the commands
and run this code

dim mydb as database
dim rst as recordset
Set mydb= currentdb
Set rst = mydb.openrecordset(Youtablewithcommands)
do while not rst.eof
mydb.execute(rst!commandfieldname)
rst.movenext
loop

 

[SQLScholar]

cool thanks mate. Beets running 40000 commands separately - STAR!

----------------------------------------
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------