Issue with my Access DB. Help needed if possible. Users Locked

[rkhondas2000]

I created a database for users to enter information. It has a switchboard users can select the form to populate and then submit the data. Everything seemed to be working fine until the last few days. Now users get an error about the file possibly being read only and you have to hit ok 3 times to enter the form. Luckily the information still gets sent over but I'm not sure if locked users is causing this issue. I tested it with 3-5 users without any issues before. I see there are 2 users stuck but since everyone logs in with admin, I cant determine the users name. Is there a way to kick those users out without tracking them down?

I tried deleting the locked access file but it didn't work. I also tried this program I saw online to kick users out and give them a minute to save their work, but unfortunately, it just kicks me out and not any of the other users while I was testing it. Worst case, I can have the users, which are about 10-12, send me their workstation ID's and then I would be able to determine which machine is stuck. I'm still surprised I'm getting any type of error since I wasn't receiving it before with multiple users.

Thanks in advance.

 

[Joe4]

First off, is your database split? Any multi-user Access database should be split into a back-end and front-end. It greatly reduces these kinds of issues, locks, and corruption.

The back-end consists of just the data tables, and the front-end is all your queries, forms, reports, VBA. Each user has their own copy of the front-end database.

See this article here: https://support.office.com/en-us/ar...database-3015ad18-a3a1-4e9c-a7f3-51b1d73498cc
If you do a Google search, there are many more on "splitting an Access database".

 

[Micron]

Is there a way to kick those users out without tracking them down?
Not in your current state.
I tried deleting the locked access file but it didn't work
Meaning? You could not delete the file, or you did and it didn't help? You can open the ldb file with Windows Notepad and get some info on who has it open (probably just their machine ID, but maybe that will tell you something). Joe4 is right. A shared file should be split.
P.S. the code you tried probably kicked you out because it isn't set up properly.