Calling a form from a referenced db

[DataMinerHome]

Hi, I have a form, frmHidden, a copy of which currently resides in the frontend of each database I manage. The autoexec of each database opens this form in Hidden mode. The form contains a timer event that does various things, such as check for inactivity. (I've been using this for years with no problems.)

Each database also contains a reference to a database "DBLibrary.accdb", which contains various functions that are used by all the other databases.

So, my question is, instead of having a separate copy of frmHidden in each frontend, should I just place a copy of it in DBLibrary and have each frontend call it from there? I know I CAN do this, but SHOULD I? Is there anything wrong with doing it that way? For example, is there some risk when I have a bunch of users calling the form at the same time? (I have about 20 concurrent users) It seems like each user would just have their own instance of the form, so it shouldn't be a problem...?

Thanks for your advice!

 

[Rabbie]

I would keep the form in each FE DB. This will mean less network traffic and so marginally better performance

 

[Thales750]

DataMiner,

Can you tell us how you did that inactivity form please?