Use an mdb as a background executable

[Bill Reed via AccessMonster.com]

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

[Access]

Do it in visual basic

[usddcm]

Simpler than Visual Basic would be vbscript.

[usddcm]

Simpler than Visual Basic would be vbscript.

[Bill Reed via AccessMonster.com]

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