Good Morning,

I have been searching your wonderful forum and I have found the answers to all my questions - or so I thought.

I have 5 people who need to use the database and I need to know who signed on and added/changed data etc etc etc.
So I looked up workgroup security and hey presto :) I have security when I open the database I need to put in my username and password.

However..... when I asked my co-workers to sign on to the database they can just open it :eek: - no questions no "hows the family" no nothing!!!!
So here I am the poor administrator having to put in passwords when the rest of the world can reek havoc on my defenceless database:D
Any help greatfully appreciated

My husband and children keep telling me humour is not my strong point and having read some of the other threads about how to ask etc etc I may well have fallen in the ignore category.

However I think I have found the answer to my question (for anyone interested) I used the User level security wizard - which has given me a shortcut to the database and identifies each user by virtue of their sign ons. (I had been warned off using this wizard previously).

So I can recommend to anyone who want to do control access to try this - make a backup copy of your db youself but the real beauty of this is it makes another copy for you as well.

Suzy

The biggest problem that people face when trying to implement this ULS is remembering to remove the user "ADMIN" from the ADMINS group. However, the second big mistake is that they remove ADMIN from the Admins group BEFORE they create another user and assign them to the Admins group so that they can do administration. If you remove the Admin from the Admins group before you assign another user to that group, you basically honk up the database to an unrecoverable state (hence the reason to back up the database BEFORE attempting to implement User Level Security).

I am not sure why the wizard is not liked by many, as I've always had good luck with it and it does help with those two mistakes regarding the Admins group.

So, it's good you got it working. One thing to note, if you haven't read about it yet, is that ULS is no longer supported in the new Access 2007 file formats. You can still use ULS in 2007 but you have to use the old MDB/MDE formats instead of the ACCDB, ACCDE formats. Just something to be aware of when you eventually upgrade.