Form IsLoaded by another user on a network????

A

AccessFitz

Hi,

I want to write some code in a command button telling me if another user has
a form open. I tested the CurrentProject.AllForms("FormName").IsLoaded. It
works fine, but I share the database w/ 2 other users on a network. I've
searched this group looking for the answer. Does anyone know?

Thanks
AccessFitz
 
G

George Nicholson

Does anyone know?

Yes: Don't do that!

Split your database. Forms are not meant to be shared, it *will* lead to
data corruption eventually.

Every user should have their own FrontEnd file which contains Forms, Queries
& Reports.
Those Frontends also contain linked tables which point to a single, shared
Backend file. The Backend file contains only data tables.

HTH,
 
Top