Manny has attended:
Access Intermediate course
Access Advanced course
Simulatenous Access within Access
Hi Guys,
it might be a slight oversight on my part but nonetheless is crucially important, where i have multiple users accessing a temporary table and it is causing errors if a record changes.
The core of my data is stored in 5 tables. Upon a "record challenge" the data is pulled via a append query into a temporary table. This then displays the information in a "recording challenge" form. if a user is challenge a record on a single user basis, he will be able to submit the change and this is fed into the main table upon validating checks etc.
The issue occurs in multi user access where 2 users could be in the "recording challenge" form (fed from the temporary table), looking at two separate records. the data is obviously wiped from the temporary table and shows multiple #Deleted items in all the fields and displays run time error 3329. Im not sure if i can attach a screen shot to this thread somehow?
The crux of the matter is how do i go about multiple user access to the temporary table and continue concurrency.
Please may you advise urgently as I am super stuck and my googling as been unsuccessful :(
Manny
RE: Simulatenous Access within Access
Hi Manny,
Thank you for the forum question.
MS Access databases can be difficult to understand. Especially when you haven't build it yourself.
The error you get:
Run time error 3329 = Record in table '|' was deleted by another user.
Tells me, that somehow the records are deleted, when a second user access the Temp Table or based on some experience I have with similar issues the form need to refresh each time a new user opens it.
The requery command refresh the data.
https://docs.microsoft.com/en-us/office/vba/api/access.form.requery
I am not sure the reguery will do the job, but this is my best idea with my little knowledge of how your database is build.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Simulatenous Access within Access
i managed to resolve. I created a temporary table and made username as primary key. that way only one user can access a particular record at a time and the delete query will only delete the record that the user is working onrather than someone elses :)
RE: Simulatenous Access within Access
Well done Manny. I am happy that you found a solution.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
