[AccessD] Is form open in another database

Ervin Brindza medela at eunet.yu
Thu Mar 13 01:08:00 CST 2003


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
> :
>
>
>







More information about the AccessD mailing list