Hi all,
First time poster on these forums and part-time Access junkie.
I have built a very simple DB designed to allow multiple users to record the outcomes of different client incoming calls. Each user (7 in total) has a copy of the FE on their local machine and the BE is stored on a locally shared network drive.
Each staff member uses a simple bound form to record the outcome of their incoming calls then simply adds the record to a table and then moves onto the next call. We are looking at about 400 calls per day, lots of new records ....
Each user has their own "Staff Number" attached to each record they add and (using the form's filter) they can only scroll through records they have added to the DB themselves. So in short, each user cant be in another’s records through the data capture forms we use.
Once or twice per day, it appears that one user will "lock" the others from adding new records or amending old records? I have attached a Word doc with some screen shots to illustrate the error and the set-up I am using.
I have searched high and low for an answer to this problem. Record locking is set to "No Locks" in both the options and the form's properties, Default open mode is set to "Shared", Open the DB using Record Level locking is enabled and randomly I am still getting "Runtime error -2147352567 (80020009)"
This is beyond me I am afraid.
Any help you may have will brighten my life
Graham