Connecting Tech Pros Worldwide Help | Site Map

Open MS Access with user-level security

Newbie
 
Join Date: Apr 2006
Posts: 3
#1: Apr 7 '06
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.
Reply