Database Permissions Nightmare

[Gary]

Hi. I have a database that I created. I have set up a
Workgroup file for security which works great when I call
it as part of the shortcut. In Workgroup Administrator
(after wards), I set the Workgroup to the Sysem.mdw file.
Now if I use the shortcut, I get my security prompt and
all is well. But if I call the database directly I get
the following:

You do not have the necessary permissions to use the
<name> object. Have your system administrator or the
person who created this object establish the appropriate
permissions for you. (Error 3033)

Shouldn't the database just use the default System file?
Is there something else I need to change?

Thanks,

Any help is appreciated.

Gary

 

[Joan Wild]

Sounds right to me. The point of securing it is that you want people to
access it only if they have been authenticated via your secure workgroup
file. If the database opens using the default system.mdw, then anyone could
open it.

Do you want people to be able to open the database without logging in (it is
possible)?

 

[Joan Wild]

Permissions are stored in the mdb file. The workgroup holds users, groups,
memberships. You can't just join another workgroup and open the database.
If you want to unsecure the database, there are steps in the FAQ to do this
http://support.microsoft.com/?kbid=207793

Basically you log in to the database, give permissions for all objects back
to the Users Group.

Open Access using the default system.mdw workgroup, start a new database,
and import all the objects from your 'secure' database. It will no longer
be secure.