How to remove security

[b_bds]

Hi

I started a database a couple of months ago and after I while another collegue continued it. I'm going back as the one in charge of that database but there is a problem. He applied a security level in the database and I get once in a while a message telling me that I can't do this or that and now I can't take it anymore. I want to remove all the security and I will apply something like this after (http://www.access-programmers.co.uk/forums/showthread.php?t=156408)

I tried this (http://office.microsoft.com/en-us/access/HP051882401033.aspx)to remove the security but it doesn't work well because my database doesn't work anymore.

Anyone has an idea on how I could do this?

Thanks
EDIT : I have all the passwords so that is not a problem

 

[statsman]

If the database is requesting just a password (No User ID), you should be able to do everything you want when you log in.

If it is requesting a User ID and Password and assuming that your collegue gave himself access to everything when he applied the security, log in as this person. You should be able to make any changes you want then.

For an excellent overview of Access security and how to do it advise, go to:
http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald.

 

[b_bds]

Hi
thanks for the reply

For your information, I don't have to enter any password. Sometimes in vb I have to enter a password but not everytime (is it normal?).

I'll be reading the Jack Macdonald paper and will see if anyting can help me.

Thanks