...

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



accessman2
04-07-2006, 04: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.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/try.mdb"
%>

Please let me know, thanks.

degsy
04-07-2006, 02:46 PM
Have you looked here
http://www.connectionstrings.com/

demtron
01-26-2009, 02: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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum