By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,963 Members | 1,863 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,963 IT Pros & Developers. It's quick & easy.

Use an mdb as a background executable

P: n/a
I have code in a db that has to run every hour to update some back end
tables to the contents of an excel file. It works fine, but I'd like it to
run quietly and invisibly in the background, in a separate mdb. It could
also produce a msgbox that could disappear after half an hour, informing me
that the code has run successfully. Something like this:

MsgBox UpdTables, vbInformation + vbOKOnly, "DMS Data Updates"
DoCmd.Quit

where UpdTables is a function that updates the backend tables and returns a
string saying what it did.

To reiterate:

I'd like the mdb to run invisibly in the background and produce a msgbox
when the code is done executing. If I'm not at the pc when the msgbox pops
up, I'd like it to close in preparation for the next scheduled execution,
after half an hour. The mdb should be invisible at all times.

I'm using the Win2K Pro builtin scheduler in the control panel to open the
mdb every hour during the workday. It would be great if there were a
checkbox in the scheduler to run the app invisibly, but there isn't. Any
suggestions?

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Do it in visual basic

Nov 13 '05 #2

P: n/a
Simpler than Visual Basic would be vbscript.

Nov 13 '05 #3

P: n/a
Simpler than Visual Basic would be vbscript.

Nov 13 '05 #4

P: n/a
Thanks for the advice, but although I've done some VB programming in the
past, I've never done any scripting or batch files of any kind. Also, I
don't have VB on my PC here at the client site. Do you mean that I should
have a vb script open up the db and the startup form which launches the
code in it's On Load property?

Any advice would be appreciated.

--
Message posted via http://www.accessmonster.com
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.