[MSAccess] [VBA] Status of query

I have a major update that the users can run to update priority numbers and all the other junk.

My question is can I use vba to provide an active status of the update queries that run. It takes them a while so I thought if I could I would like to show whats going on.

The code at this point is not to important I just don't know which way to go with this. Use docmd.runsql, open db.execute, or adodb/dao database connection... Can't seem to narrow down which way to go to provide a status.

What I would like to see is: Record 27/13000 Updated and then just keep counting through as its updating. If it has a progress bar it has to get the value's from somewhere right?

Thanks,

TheChazm