Multi-user database deployment

  • Thread starter Thread starter hjgoldstein
  • Start date Start date
H

hjgoldstein

Dear all,

I have a database which I want to share on a Citrix Metaframe network.

I have set up user level security and then split the database into front-
and back-end. the back-end will, of course, be in a shared folder on the
server, and I will distribute the front-end to each user to deploy on their
Citrix desktop.

Here's where the issue arises. In the shortcut which opens the front-end i
have the following (for my desktop):

Target:

"X:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "X:\Documents and
Settings\i06547\Desktop\AuditFE.mdb" /WRKGRP "P:\AuditDB\AuditDB.mdw"

Start in:

"X:\Documents and Settings\i06547\Desktop\"

As you can see, the path to the desktop is ...\I06547\... which is my user
name for this particular network.

Am I over-complicating things? Is it possible to leave the front-end in a
shared folder as with the back-end and avoid having to customise the shortcut
for each user? If not, I shall have to bite the bullet and do it the long
way round.

Any advice or assistance would be appreciated.
 
You beat me to posting, Arvin. This morning, I spkoke to a network
administrator who is setting up a root mapping to the personal folder.
Problem solved.

Thanks for your response.
 
Back
Top