how to deploy MS Access with SQL Server on Citrix

[jeed]

Hi, I have an MS Access application, I plan to move all tables and queries to SQL Server because I 'd like
to centralize my database and also my application. If I use Citrix, how can we share a single copy of my MS Access application with SQL server to multiuser? I have tested by create one accdb file and link table via odbc to sqlserver. I copies this to citrix server and then two users access this application concurrently via citrix client. The error is saying that 'Microsoft office access can't save design changes
or save to new database object because another user has file open'
It seems the file is locking, however my access application is in Shared mode (Advanced option)

I am quite new to MS Access, Please help to described how I can meet my objective so that multiuser can access same single copy of MS Access application with data on SQLServer at the same time via citrix. Do we need to split or compile or do any special setup? Thank you very much.

[MrDeej]

I dont know what you have trouble with, but we are also sharing a access application on a citrix plattform. It works without errors and many users can log on to the same accdb.

[jeed]

I dont know what you have trouble with, but we are also sharing a access application on a citrix plattform. It works without errors and many users can log on to the same accdb.

Hi,
Thanks for your reply, how do you share it on citrix? please help to describe because I am quite new with access application. Do we just copy accdb file to citrix server, then share it and map to network drive, do we? Is it just single copy of file and everyone from citrix client can access it? Any special setup on access required? Thank you very much for your help

[MrDeej]

We have shared the file from å public network place, we also have made the mdb as a "applicatio n" in the Citrix logon screen.

I.E. where we have Desktop, Mail etc we also have the database.