Need to know who is in the file

[khughes46]

How may it be determined who has a front end copy open? I need to know because when a front end is open it locks me out of the back end. I thought the split was supposed to relieve that problem. Both ends are in their own shared folders on the same server.

[ItsMe]

You might be able to copy and open the laccdb file using a text editor to determine who has their file open. I would recommend dedicating a table to Users on the BE. Then, when a User opens their app, you can have a form open that determines who they are and update a table on the BE what their login status is.

[Perceptus]

Goto Run
enter in the following, where PCName is the PC that holds the file
compmgmt.msc /computer:\\PCNAME
On the left hand side, there is a System Tools. Expand This. Goto Shared Folders, Goto Open Files. Now click the "Open File" column on the top and it will sort all the results. Look for the File named that of your database. This should list all open file handles for that database.

Alternatively, You can just run Compmgmt.msc and after it opens, choose to connect to another computer. That other computer being the one where the File resides.

[ssanfu]

Both ends are in their own shared folders on the same server.

The BE is in a folder on the server?

EACH usershould have a copy of the FE their computer.

DO NOT allow multiple users to open the FE from the same shared folder on the server.

[Perceptus]

You will want to look for the File handles that are the name of your backend. Multiple users opening the same FE from the same shared folder is a practice not advised. Its not saying that you can't do it and have no problems. Its just like driving without a seatbelt. Or bunji jumping without checking the knots first. Its far safer for the data when Its split up per ssanfu.