Citrix farm - multiple databases

[Svend]

I don't know much about access, hence I'm asking you guy's.

We have a Citrix farm that services about 60 users across
3 servers. If you don't know about citrix, just think of
it as three workstations shared among 60 users.

Various groups of users share access 2000 databases and
some of these want to implement security within the
databases.

Does each database use it's own secure.mdw (or system.mdw)
file?

There is a registry setting for the location of the
secure.mdw file. This was
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0
\Access\Jet\4.0\Engines\SystemDB. Is there a user specific
version of this registry key, I find that changing this
setting effects all users. This is not what we want as
users may not have access to the location where the MDW
file is stored if it set on a per machine basis?

Any explanations appreciated.

Thanks,
Svend.

 

[TC]

I'm off to move my car, so this is just a quick reply!

The mdw file defines user names, passwords, group names, & user/group
relationships. It does not have any permissions as such. Each user & group
is assigned a unique identifier called an SID.

The mdb file contains tables, queries etc. (as you doubtless know). The mdb
contains an internal cross-reference, along the following lines:

item SID permissions
my_table 111 add, edit
my_table 222 add, edit, delete
a_query 111 (none)
and so on.

By those means, a workgroup can control several different databases (if
that's the way you wish to go).

To control *which* workgrioup is used when you open a database, start the
database using a shortcut with the following target (all on one line)

"path to MSACCESS.EXE"
"path to MDB"
/wrkgrp "path to MDW"

HTH,
TC