Error Mylti-User
- Thread starter calvinle
- Start date
Wow, and now, the old problem came back. It prompt Invalid Bookmark, and then, 4 lines becames #Error. I open the backend, and it says, Access has to repair the error. It then générâtes a report.
View attachment MSysCompactError.zip
View attachment MSysCompactError.zip
The error does not appear when only 1 user add data. I didn't have the chance to have my user testing it yet.
It's also hard for me to retest that way as my table are related to another table. I will have to manually readd all the related data which is long.
I will test it tomorrow with another user trying to add data both them and me at the same time.
It's also hard for me to retest that way as my table are related to another table. I will have to manually readd all the related data which is long.
I will test it tomorrow with another user trying to add data both them and me at the same time.
I did not have the chance to do all that today. What I've said earlier what the experience the whole time last week and this morning until the crash. I had to stop the user to use the database to enter new data today until I find the fix.
I have a feeling that it's the LAN problem. The speed that takes to save the record to the backend in the LAN for each user. The interference of the connectivity causes that. I will be leaving on vacation this thursday, so if I cannot find the fix, I will have create 1 table per user... :/
Hi,
I have made a quick sample to check the possibilities of the problem.
I have created a new database with a backend of a sample table connected to the LAN, and subform without any coding. So the data entered by the user and me will feed to the backend. The test went well and even at high speed of entering data to it, no bug.
I have done another test, but in a filtered mode, the test went well with no bug.
I have done another test, using the link parent & child to a combobox, it works at slow speed, then fail at high speed.
I guess the problem is the link parent & child vs the LAN.
I have made a quick sample to check the possibilities of the problem.
I have created a new database with a backend of a sample table connected to the LAN, and subform without any coding. So the data entered by the user and me will feed to the backend. The test went well and even at high speed of entering data to it, no bug.
I have done another test, but in a filtered mode, the test went well with no bug.
I have done another test, using the link parent & child to a combobox, it works at slow speed, then fail at high speed.
I guess the problem is the link parent & child vs the LAN.
Now the tool bugs again. I don't think it's necessary to spend more effort on this.
I am now thinking of 2 other ways, can you provide your feedback?
The user will have their own frontend.
On the main form there will be 2 button, 1 for add data, 1 for view data.
In the add data form, the data will be entered in local table, and once form is close also via a command save button, the data will be save to backend regardless the PK of local table, so the PK in backend will be created automatically.
Also, when someone is saving data to backend=only 1 connection at a time is allowed. If already connection already existed, which mean someone is saving on the backend, it will prompt the second user to wait until the save is completed.
There is the view form which is the same except no add allow, only edit.
What do you think?
I am now thinking of 2 other ways, can you provide your feedback?
The user will have their own frontend.
On the main form there will be 2 button, 1 for add data, 1 for view data.
In the add data form, the data will be entered in local table, and once form is close also via a command save button, the data will be save to backend regardless the PK of local table, so the PK in backend will be created automatically.
Also, when someone is saving data to backend=only 1 connection at a time is allowed. If already connection already existed, which mean someone is saving on the backend, it will prompt the second user to wait until the save is completed.
There is the view form which is the same except no add allow, only edit.
What do you think?
