My database doesn't ask for a logon?

[erwin001]

Has anyone had the following problem? I built a database application, and placed it on a server. I secured it through access using the wizard. I also set up approximately 7 users spread throughout the US. Each time any of the 7 users access the database the program doesn't request a user logon. When I attempt to access the database from the same server, if functions as designed. It requires me to provide a logon and password. One additional problem from my is the following. It seems after a few days or so, when I open the database , the application doesn't request the logon and password anymore. I have to reset the security.mdw file. Has anyone else experienced similar problems?

 

[hneal98]

When you set up the security, did you take out the admin account? You need to create a new account and rename it to something else, give it admin rights and then delete the default admin account.

By default, everyone is given admin rights, that is why you have to create a new admin account and delete the one called 'admin'.

Hope that helps.

 

[hneal98]

Actually I need to qualify that. If you are just creating a login, this would not apply, it only applies if you are setting up a whole security package and assigning people to groups or rolls, etc.

 

[erwin001]

Thanks. Actually, If I'm not mistaken, I'm attempting to setup the whole security package. I'm assigning members to different groups based on the assigned permissions. Therefore, your solution sounds like its the way to go.

 

[hneal98]

That should do it then.