I created an Access Database with different level of security setting and put it on the intranet for my department. However, when they open the file, Access did't promt the login boxbut a box saying they didn't have the authority to open the file.
Does anyone know why's that?

Because of this, I'm thinking to uas .asp for them to access the Database. But then, I have no idea how to set the security if I changed it to web based.
Could anyone please teach me how to do?
Do I need to delete all the user account I set?
I have no idea where to start.

Thanks

If you use asp, just password the site, and give user's access based on their site credentials. When you go to the intranet like this, just use Access as the _fpdb (if you are using FrontPage) and use asp for security, not Access.

The problem may be that you pages are not passing credentials to Access. You may be able to grab environment values from the user machines and then pass these to Access. I have not done that but I know you can.

Anyway, I would use asp security. Try MSDN.Microsoft.com and do a search.


mmcdonal