Multi users making synchronous changes to SharePoint list in Citrix environment

[Alexander2013]

Hello,

I currently have the following setup for my database which is working as desired when only being used by one user at a time:

Front end: Access 2010 database in Citrix
Back end: SharePoint List

The problem is that only one user can open the Access Database at a time since this action locks the database for other potential users. The locking occurs due to this link to the back end SharePoint list.

What is the best solution to allow multiple users to update the SharePoint list through the access database at the same time?

 

[Pat Hartman]

Welcome aboard
The problem is the way the FE is used in Citrix. Administrators, unless they have set up Access applications before, don't seem to understand that each user MUST have his own personal copy of the database. Try to explain to him that when a user opens the FE, a copy should be made in his own personal work space that he and he alone can work with.

I don't use SharePoint but my understanding is that the lists are shareable so fixing the Citrix issue should solve the problem.

 

[Rx_]

Pat is right on target (as usual). Citrix works really well this way. My guess is that Share Point is driven by SQL Server. My Access Citrix site runs really well. This is an example of the code handed off to the network guy.

The code makes a directory in the user's home directory and then copies the file over and then starts it. So basically, the developer puts out one single copy of the Access Front End. When the user request it, the user gets a copy of that put into their personal User folder.
This way, each of the many users have a Front-End.


@echo Please wait while a copy of the Access DB Front End is copied to your individual users folder.
@echo off

MD "L:\Database\"
xcopy /Q /Y R:\FE\Current\TaxAuditAssignments.mde "L:\Database\*.*"
TYPE NUL | choice /c:delay /td,5 >NUL
Start /max "E:\Microsoft Office\OFFICE11\MSACCESS.EXE" "L:\Database\TaxAuditAssignments.mde"

exit