Hello,
I have a 2003 database set up with about 20 users (only about 4 at a time) but I repeatedly get a problem with the records all locking. Each User is assigning billing codes to jobs so they each run a query that selects different work packs and then go through just those records. so there should be no way that the records should be the same.
There is an issue when we run the append query to add more data to the table but it also happens at other times when there are just three of them working on it. is there anyway to remove all locking? I have each client database set to open in Shared as well as the server side and the default locking is No Locks, the error it comes up with is Can Not Update record currently locked. normally when it happens I have to get each user to shut down before restarting it. so really need to stop it locking in the first place.
Thanks
Adam