Another User Has Exclusive Access

[ARW17]

I can't get multiple users in a new database. When I've written previous databases, I split them and made multiple front ends and had no issues. I've been working for weeks on this and can't figure it out.

What I've Tried:
1. The database is split and the BE is in a separate folder from the front end.
2. I've made multiple .accdb and .accde front ends, but the error is in both.
3. We have 3 users. They all have Client Settings>Advanced>Default Open Mode>Shared AND Client Settings>Advanced>Default Record Locking>Edited Record.
4. We're all working in full versions of MS Access 2013.
5. We all have permissions to access the files where the front and back ends are stored.

We can't get our work done if only one person is in it at a time. I need serious help. Anyone have additional suggestions? The last db I worked on, most folks had the reader and they used .accde files. Does this have something to do with it? Also, should I be seeing a lock symbol on my .accde files when they're not open?

TYIA

 

[xenou]

Every user can get in? But not concurrently with another user?

 

[Micron]

Is anyone/everyone using a shortcut to open the fe, but that shortcut was designed to open exclusively? It is possible to do that.
Are you sure everyone's not trying to edit the same record on startup, such as in a login table or similar?
You have properly set up the fe's (as mentioned above) but you have a conflicting setting on the be?

what does this mean - the lccdb file icon?

Also, should I be seeing a lock symbol on my .accde files when they're not open?

 

[xenou]

I think you should see the lock icon when one or more people have the database open. Actually in a quick test I see it even when the database is not open by anyone. So maybe it's just a weird icon.

However, you should not see an [same_databasename].laccdb file if *no one* is using the database.

 

[Micron]

In this case, perhaps, but 1 reason why you might is because a user wasn't given delete rights on the network folder thus it remains for a time.
I opened a 2016 db exclusively but couldn't see any locked icon on it.

 

[ARW17]

Yes, that's right. Everyone can get in if they're the only ones. Does it have anything to do with full Access versions instead of just readers?

Upon opening, they're trying to choose a person and a type of work to grade.

 

[xenou]

The only thing that I know of that makes any sense is making sure the database is not set to open with exclusive access (i.e., particularly the back end database). As described here: https://stackoverflow.com/questions/19777323/set-database-to-open-in-non-exclusive-mode

 

[james_lankford]

> 5. We all have permissions to access the files where the front and back ends are stored.

it still sounds to me like everyone is opening the same front end

everyone needs their own copy of the front end

 

[xenou]

everyone needs their own copy of the front end

technically I don't think that is true, or at least it should work and I don't see where it would cause this problem. Just my two cents

Note - unless of course either the FE or the BE or both are set to open with exclusive access which is my first and only suggestion.

 

[ARW17]

Ok, I'd like to pivot this a bit. It seems like there are 2 specific forms that won't work with 2 users at a time. It isn't the database itself. What would prevent users from using the same FORM at the same time, as opposed to the whole database itself?

I've triple checked that neither FE or BE are being opened in exclusive mode.