View Full Version : Open MS Access with user-level security

04-07-2006, 03:38 AM
I have a question.
I want to open the MS Access file with user-level Security.

I know that if I do NOT setup user-level Security in the MS Access file, and create the table for login in the MS Access file (Put the MS Access file in the server), then it works. I did that.
But, I want to know whether or not we can use ASP code to open the MS Access (MS Access user-level Security setting). This way I can put the MS Access file in the public place.

Can we do it in ASP?

The following code cannot do that:
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "c:/try.mdb"

Please let me know, thanks.

04-07-2006, 01:46 PM
Have you looked here

01-26-2009, 01:46 AM
I have created multiple ASP and ASP.Net sites that use Access user-level security. www.connectionstring.com is, for certain, the best resource for help with coding this kind of connection. It is important to note that the .mdw file must also be accessible by the Web server in order for the connection to work.