Recent content by Danylo

Thank You Everyone for contribution and a lot of useful and precious information, I'm happy to say that solution is found. Thank you everyone who pointed to wrong sharing approach, during the test with LAN sharing, the issue disappeared.

QNAP NAS situated on different building and on different network

Regarding this dispute, I consider it unnecessary to continue it, as I've said I have no experience with Access, and I'm here to find the help and gain information from people who have much more knowledges about Access and databases.

Currently, I've started the test in which, BE will be shared over LAN , hope it will solve the issue.

I'm not pretending to know a lot about Access, as I mentioned, I have few days experience with Access, but ideas like that : " Access has been designed for single user use. It experiences severe performance issues when multiple people try to access it through the network simultaneously. Though...

Thank you for your reply. Users are not using VPN, BE is stored on QNAP NAS situated on different building, by itself it's cloud storage solution, on which there is a folder with BE part of the DB, after that each user is connected to that shared folder by IP. I'm not really sure, whether I...

Hope all my previous answers, fully cover mentioned questions.

Thank you, the only reason for that was to gain as much useful information from different communities as possible, even in current thread we can see replies from a members of AWF with such a different opinion.

Regarding sharing a BE on the LAN, thank you I will try that solution, and will share the result. Considering locking, both optimistic and pessimistic approaches were tried and none of them fully solved the issue. During Optimistic Locking, 'priority' user never receives conflicting error...

I understand that using multi-user simultaneous approach in Access is a really bad idea, since regarding the information I've gained in the last days, access not really a suitable solution for multi-user simultaneous work no matter if there is locking system or not. But I'm still confused about...

As I mentioned in the issue description, built-in record-locking is really useful but they don't fully solve the issue.

Thank you for your reply, I share your opinion and solution. During attempts to solve the issue, my colleague and I tried different locks configuration, and it seems to solve part of the problem but we still have issue that 'priority' user doesn't receive the changes made by other users. If...

Thank you for your reply. As I mentioned in my previous reply BE is stored on QNAP NAS situated on different building, by itself it's cloud storage solution, on which there is a folder with BE part of the DB, after that each user is connected to that shared folder by IP, and it's done to let...

Thank you for your reply. To be more precise BE is stored on QNAP NAS situated on different building, by itself it's cloud storage solution, on which there is a folder with BE part of the DB, after that each user is connected to that shared folder by IP. About why such approach was used, I...

Thank you for pointing that mistake I've made, I fully share your opinion. I just was in hurry to post the issue thread, and due to spreading the attention between the main project and that issue, I may need a little bit longer time to answer on supposed solution, but I really appreciate all the...