2k3 Terminal Server Problem with ADE / Access

[Guest]

Hi

I'm having a problem with a terminal server installation on server 2k3.

I have an MS Access 2003 database, thats actually an ADE file that I host on
the server. Since it's an ADE, its tables and queries are actually hosted on
a separate SQL server.

When I launch the database on the TS, it opens fine and everything is great.
However, if anyone else opens it while I have it open, they get a message
saying they have to open in read-only mode, that the file is locked for edit
or was purposely opened read-only.

Any idea how to fix this?


I can open 2 copies of the database on my laptop at the same time and it
works. I installed office and this database in 'install mode', if that makes
a difference.

Thanks in advance

Josh

 

[Guest]

I dont if this helps but I had the same issue but I was running citrix and
under the publish app here is the command I used to run the app

"C:\Program Files\MicrosoftOffice\Office\MSACCESS.EXE"
"C:\App\file\program.ade*"

and I have each user in there own working directory

X:\User\Usr01

X is coming from there AD profile.