[AccessD] Is form open in another database

Stuart,
great idea, it's almost friday here :)
Many thanks,
    Ervin
----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Ervin Brindza" <medela at eunet.yu>
Sent: 13 March, 2003 9:44 AM
Subject: Re: [AccessD] Is form open in another database


> Why not a system table in the BE.
>
> tdlOpenForms:
> fldUserName
> fldFormName
>
> In the on_open of the form write a record to the table
> in the on_close, delete the matching record.
>
> > Francisco,
> > thanks for the quick response :)
> > I have 3 disputable forms(e.g. frmA, frmB, frmC), and have a couple of
> > users(1 user on each machine, e.g. PC1, PC2, PC3, PC4, PC5). The
solution
> > might be to create files for each active form for each machine(e.g.
A4.txt,
> > A5.txt then the form frmA is active on PC4 and PC5) and when the form is
> > closed then to delete the appropriate file. I think it'll be the best
> > solution because there is just a couple of forms and users.
> > Maybe someone can suggest a better solution, to make less files and to
check
> > are files empty?
> > Many thanks for the idea, best regards,
> >     Ervin
> >
> > > What I do now is create a text file called lockout w/ a time, when a
> > > specific form is open all it would have to do is check for this file,
all
> > > specific forms that need to check if the BE's been locked out would
check
> > > this file first and if it existed then BOOT!
> > >
> > > -Francisco
> > > http://rcm.netfirms.com/
> > >
> > > On Wednesday, March 12, 2003 9:56 PM [GMT -8],
> > > Ervin Brindza <viner at EUNET.YU> wrote:
> > >
> > > : Cross posted to Access-L & AccessD
> > > :
> > > : My customers use the same BE file, which resides on the server,
> > > : through their local FE files. Is there a way to check if a specific
> > > : form is open on a specific machine or any of  the machines? Because
I
> > > : need to kick out all users before running some append and delete
> > > : queries.
> > > :
> > > : Many TIA,
> > > :
> > > :     Ervin
> > > :
> > >
> > >
> > >
> >
> >
> >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
>
>
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
>
>
>
>