[MS_AccessPros] Re: How to Run a procedure in the background?

 

Onno

I'd use a shell command to open the second FE minimized. Put an AutoExec macro or a startup form with a form Load event to call your procedure. At the end of the procedure put a Quit command to close the database.

But is all this necessary? Does the update take a long time to run? 

-Bill

---In MS_Access_Professionals@yahoogroups.com, <onno.knol@pbl.nl> wrote :

hi Bill, thanks so far. 

So i can create a second front end database to run the update procedure.

Now how can is start that from the main frontend? 

Should i use the shell command to start another  the second frontend, and then how should i automatically start the procedure ?

Or is there a more flexible way of interacting with a second frontend from the mail frontend without the screen freezing while the second frontend is running the update?

Thanks for your thinking ..

 Onno

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___