Subject: Security .asp
Posted By: J.K.W.Y. Post Date: 4/17/2006 10:33:00 PM
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

Reply By: mmcdonal Reply Date: 4/19/2006 6:44:38 AM
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

Go to topic 42669

Return to index page 310
Return to index page 309
Return to index page 308
Return to index page 307
Return to index page 306
Return to index page 305
Return to index page 304
Return to index page 303
Return to index page 302
Return to index page 301