MsAccess 2010 throught CITRIX (1 Viewer)

[LarryC]

:banghead: I am running into a problem of Users Unable to Add or Update any Information when they are running an MsAccess Application through A CITRIX Server.

the Application Allows User to Enter Data (linked SQL Server tables) and Run / Modify Queries

When Multiple Users are in the Application everyone after the first is given the Message "You Do not have exclusive contol of the database at this time. If you proceed to make changes , you may not be able to save them later". the user(s) are normally only doing data entry. there are some that do change queries for some reporting info.
All data is being stored in SQl Server 2008 R2 Tables.
In all Previous version CITRIX Opened a New "instance" of the DB for each User. My Question is Does MsAccess 2010 get treated different?

CITRIX Version is 11.0.0.5357 ( 256-bit SSL)

Any Help would be appreciated

 

[boblarson]

You need to have each user have their own copy of the frontend. We solved that by making the published app icon actually be a command batch file. It then makes a copy of the frontend to the server they are on in a temp folder for them and then it opens the front end.

Here's a copy of our batch file. We also have a batch file delete their temp folder when they log out.

@echo Please wait while the version of the database you requested is updated.
@echo off
reg import e:\Access2007TrustedLocation.reg
REM reg import e:\All.reg
MD E:\BKY_temp\%username%
copy R:\FE\Current\Consolidated_Reports.mdb E:\BKY_temp\%username% /y
Start /max "E:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "E:\BKY_temp\%username%\Consolidated_Reports.mdb"
exit

And we call the reg file to set the trusted location

Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\Location0]
"Path"="E:\\bky_temp\\"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="9/25/2012 1:00 PM"