Stop User from opening FE MDE File twice

Are you saying only having one user in the FE at at ime? is the FE on the local computer or a network?
 
Im sorry for not being specific, The BE is on the Server and each user in their workstation computers (local computer) has its own FE. What i want to do is to stop the user from having more than one instance of the same MDE File in their own computer so when he tries to open the same MDE file having it already open, it will just set the focus on the one already opened like the MDB files do when you "open twice without closing the first one".

Thanks for the reply s, i will check the link ByteMyzer gave me.

EDIT: Already checked your link, I would like to have multiple instances of a db but not more than one in each computer.
 
That's why I posted the link. The information shows you how to do just that.
 
Yeah you are right but i was thinking, maybe if i check if the ldb files exists then close instance. With the fileSystem Object with FileExists function, maybe will save me all of that code.
EDIT: Bad Idea it creates it before running the first stack of code

ill use what bytemyzer's link says, thanks bytemyzer
 
Last edited:

Users who are viewing this thread

Back
Top Bottom