run stored proc and release vba (1 Viewer)

[spinkung]

hi

i want to run a stored proc on one of our servers but the proc can take a while to run. It means that the access db can't be used until it completes. I'd like to fire it from vba but then release the access db and just have it running on the server so the user can go on using the access db.

I have thought of a way which can probably do this but wanted to know if there is a common method?

i was thinking something along the lines of: create a table in the db with a single column/row which is updated to a value of 1 (or something) via vba. This will cause a trigger to run the proc on the server and reset the value to 0/null when it's complete.

it's a bit messy but it'll work.

 

[namliam]

I would (probably) have a "shadow" database, that triggers the SP...
I would then from my own db start the shadow DB as a hidden application, which writes to your "own" db a value when done.

Have a hidden form inside your database open checking on a time interval if the value is set and prompt the user that the process is done...