Need access help... (1 Viewer)
- Thread starter Reeses
- Start date
No cause once they are audited and released we no longer have the packages in those locations. They go to a different area out of our department and are documented in a different system that my company uses. This database that I created is strictly just for my department to keep track of the packages we receive.
Hey all! I'm back again. Lol. And since yall are so awesome and helpful, I have another issue. Lately sporadically, my coworkers are getting the error "could not update, currently locked" when they try to enter information and save it. It's happened twice so far and once they all restarted their computers it was fine.
What could be causing this? I have it set to no locks so I'm not sure why this is happening. Any thoughts? It is possible 2 people are adding info on the same record at the same time, but not in the same fields.
Also, I tried that Me.requery in the "find record" command button and when I would hit the button, nothing was coming up to allow me to search. So I took it out and it was fine. Weird.
Any ideas will be appreciated.
What could be causing this? I have it set to no locks so I'm not sure why this is happening. Any thoughts? It is possible 2 people are adding info on the same record at the same time, but not in the same fields.
Also, I tried that Me.requery in the "find record" command button and when I would hit the button, nothing was coming up to allow me to search. So I took it out and it was fine. Weird.
Any ideas will be appreciated.
- Local time
- Today, 12:47
- Joined
- Oct 29, 2018
- Messages
- 21,454
Hi. If this is a new issue, you might consider starting a new thread to get a fresh look from other contributors. Update conflicts happen at the record level, not at the field level. So, if user 1 updated field 1, and user 2 updates field 2 for the same record, you could still get a write conflict error.
