You can connect to the db in code inside the form when you need to. The beauty of the external form is you do not have to be connected in order to run it. This gives you more options.
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Thursday, July 28, 2011 4:49 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Form Timer and Hourly backups Thanks for the offer Jan I am trying to rethink how I do things and think this through. One problem is we count the number of connections to bypass some of our start up routine like Autochk's if someone is connected to the DB, if we use an External main menu form and the user is not connected to the db we would have to change that code logic. Marc From: jan johansen<mailto:[email protected]> Sent: Thursday, July 28, 2011 4:22 PM To: RBASE-L Mailing List<mailto:[email protected]> Subject: [RBASE-L] - Re: Form Timer and Hourly backups Marc, An External Form File is a form that is not-attached to a table. This allows you to have a form that is not connected to the database unless you want it to be which is ideal for a main menu. It is very easy to convert your main menu form to an external form. If you need the steps let me know. Jan -----Original Message----- From: "MDRD" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 28 Jul 2011 15:54:40 -0500 Subject: [RBASE-L] - Re: Form Timer and Hourly backups Mike This is my main menu form that is attached to a dummy table, I am not sure I completely follow but I will look into it. Thanks Marc -----Original Message----- From: Mike Byerley Sent: Thursday, July 28, 2011 1:44 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Form Timer and Hourly backups Use an External Form.... ----- Original Message ----- From: "MDRD" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, July 28, 2011 2:19 PM Subject: [RBASE-L] - Form Timer and Hourly backups I am working on using the Form Timer to do hourly backups. I popup a Pause 3 with a gauge, Authochk, then Unload All and I noticed that if I am in a form it stops me from using the form which is OK. Will this cause a problem if I am running some big command block with several Updates or printing monthly statements when this fires? Thanks Marc
