Workgroup assignement to database

[Luong]

Hello,

Is there a way to find out which workgroup is assigned to
which database?

I have several databases and workgroup created at
different times. And since the data have been moved and
changed several times, I am having problem with permission
issue (don't have proper permission to modify data, etc.).
If I know which workgroup I have joined to when I create
the database, I have create a shortcut to point to the
proper workgroup for the database. Thanks

 

[TC]

The answer, >in theory<, is Yes. The "security identifier" (SID) of the
Admins group is stored in the workgroup file, and also, in each database
that is secured against that workgroup file. So in theory you could write a
program to match them all up.

In practice<, you will not be able to do that, unless you understand the

internal structure of Jet MDB files. One of the two values you need, is not
exposed by any normal means. You can only get that value by reading the MDB
files at a binary level.

So in practice, the answer is No :-(

HTH,
TC