user-level securitywizard problem

[hotmalepiyush]

i created this database but am not able to create a password for the same..
actually i tried the security User Level Security Wizard and created a user.. i thought i was the admin but now i am getting an error message that "you dont have the permission to open "c:\...\filename" for exclusive use.

what can i do..
plz help
piyush

 

[statsman]

In 25 words or less.

When you created the database, you were Admin. Admin is the default user. Since Admin owns the database, Admin cannot be restricted.
When you created your user, you probably tried to give yourself the same permissions that Admin has. Since you already have an Admin, why not delete your new user and settle for being Admin.

The database password function OR the Group Security should be used. While there is no great problem in using both, by using both you are introducing a redundant step.

Almost everything in Access can be learned by trial and error EXCEPT USER/GROUP SECURITY.
Get yourself a good guide and follow the steps. I would recommend:

http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little long but it tells you everything you need to know.

 

[hotmalepiyush]

cannot open any access file

hey thanx..
i am reading the pdf.. its long..
meanwhile can u help me at this:

yesterday i created a user and set a password for it. i was able to open n close access files then. now i cannot open any access file.. not even create new. its asking me Administrator Password. even by changing user's name to that user i created yesterday isnt helping.. i am in a fix i cannot use access at all. please help.