Anthony said:
Why does our database run fine when executed from our lan, but the same
database says "Could not lock file" when executed from the citrix window?
The citrix login is 'Administrator'.
Does the Citrix administrator account have read write delete rights to
the folder which contains the database?
Why are you using a Citrix administrator account to test things? You
should be using a user account.
Have you split the database? Are you giving each user their own copy
of the FE MDB/MDE?
You want to split the MDB into a front end containing the queries,
forms, reports, macros and modules with just the tables and
relationships. The FE is copied to each network users computer. The
FE MDB is linked to the tables in the back end MDB which resides on a
server. You make updates to the FE MDB and distribute them to the
users, likely as an MDE.
See the "Splitting your app into a front end and back end Tips" page
at
http://www.granite.ab.ca/access/splitapp/ for more info. See the
Auto FE Updater downloads page
http://www.granite.ab.ca/access/autofe.htm to make this relatively
painless.. The utility also supports Terminal Server/Citrix quite
nicely.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm