My problem is this:
I have created a database, using Workgroup security features. Unique
Workgroup. New users added. Permissions to Admins, Admin, and Users revoked.
'Ownership' of database objects has been given to a custom User, and has not
been left as owned by Admins.
I transfer this file (and its Workgroup) to a shared drive on a LAN.
From the original client PC that originated the file, the database cannot be
opened without invoking the appropriate Workgroup. All well and good.
BUT, when accessing the database from another client PC on the LAN I can
open it (the database) without the unique Workgroup, and without any
problems and full access to all areas of the database.
Now, I know you are thinking that I have not revoked permissions in Admins
etc. I have, see below 'cos this gets wierder...
Let's call the database 'DatBas', and say it's on a shared drive 'K:'
So, 'K:\DatBas' is its location.
When I open 'K:\DatBas' via the PC that originally contained the file, as
noted above I need to invoke its Workgroup and enter correct
Usernames/Passwords.
When I view 'User and Groups Permissions' under Tools/Security. Admins Group
has all permissions revoked. As it should be.
BUT
When I open K:\DatBas via any other PC on the network, not only do I
breeze through without any invokation of the associated Workgroup, when I
view 'User and Groups Permissions' under Tools/Security. Admins Group has
all permissions GRANTED.
HOW ON EARTH can the same file, when viewed on different machines, have
different Group permissions assigned?
It is the same file! Why (How?) can another PC simply reset the Admins Group
Permissions of its own accord?
I have sent this file to a colleague who uses a different LAN, and the same
thing happens.
What else can I tell you? Well, I store the Workgroup file in the same
location on the shared drive (i.e. so its not on the local C: drive of any
machine);
The version I'm using is Access 97.
Any thoughts out there?
Chris