User FE access locks BE

[khughes46]

I have a split DB with all my tables in the BE and everything else in the FE. When my users open the FE it locks the BE. I thought the split would let me have access the BE when the users are in the FE. Both are in shared folders on the same server. What am I missing or not understanding?

[ssanfu]

Do both dBs (FE & BE) have have default open mode property set to "Open Shared"

Access Options/Client settings/Advanced

Look for -> Default open mode should be set to "Shared"

[khughes46]

Just checked, both are set to shared. What next?

[ssanfu]

Didn't read close enough.....

I thought the split would let me have access the BE when the users are in the FE.

What do you mean by "let me have access the BE"? Are you trying to make design changes to the BE while users are entering data?

Both are in shared folders on the same server.

EACH user should have a copy of the FE on their computer. Not a shortcut to the FE on the server.
Each FE is linked to the BE is on the server.

If everyone used the SAME FE, you WILL corrupt the BE. Might be sooner, might be later, but it will corrupt.

[khughes46]

I have 1 BE and 1 FE. You are saying that if every user copies that 1 FE the DB will eventually corrupt? How would I get the users their own copy without having multiple FE's? Or will I have to have multiple FE's?

[ssanfu]

You are saying that if every user copies that 1 FE the DB will eventually corrupt?

No, I'm saying if every user has a shortcut to the 1 FE on the server and multiple users are making data changes at the same time, the BE will eventually corrupt.
If only one user is in the dB, there wouldn't be any problems. (not very practical or useful)


OK,to begin:
1) BE is on the server.
2) FE is on your computer (doesn't matter where - I usually have it on the desktop)
3) Link the FE to the BE.


Now:
1) EACH user gets a copy of the FE on their computer, NOT a shortcut. NO ONE opens a FE from the server. I have code in my FE to check if the FE is on a local computer or a server. If on the server, gives a message "Must be on a local computer" and quits.

So if you have 5 users (not including you) there will be 5 copies of the FE on 5 computers and one (master copy) on your computer.
If/when you make changes to the FE, then each user would need a new copy of the FE to replace the one currently on their computer.

To make changes to the table structure in the BE, you need exclusive access - no one can have a FE open.


---------------------------------------
I'm probably not explaining it very well.
Maybe these will help. I Googled:
"access FE linked to BE"

References:
https://support.office.com/en-us/art...3-51b1d73498cc
http://www.opengatesw.net/ms-access-...-Practices.htm
http://www.hitechcoach.com/index.php...split-database

[khughes46]

Wouldn't this work if the FE were in a shared folder on the server? This what I have and have instructed the users to copy this FE to their desktop.

[ssanfu]

This what I have and have instructed the users to copy this FE to their desktop.

Yes, this will work. As long as they don't open the FE from the server.

[khughes46]

Thanks, will be closing this one now.