Connecting with ASP to MS Access database protected with user_level security
Hello,
I created a MS Access database and I have defined the user level security.
Now I am trying to access the same database using the ASP. I wrote following
code:
<%@ LANGUAGE = "VBScript" %>
<%
'Create ADO Connection object
strDSN = "FILEDSN=Kino.dsn"
Set cn = Server.CreateObject("ADODB.Connection")
'Open connection
cn.Open strDSN, "usrid", "pwd"
%>
And when I try to insert some data into tables
<% SQLQuery = "INSERT INTO Kino(Ime, Grad) VALUES ('" & F_Ime & "', '" &
F_Grad & "')"
cn.Execute(SQLQuery) %>
I get the error message
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be added; no
insert permission on 'Kino'.
/test_asp/DodajKino.asp, line 37
But if I use the same password and user id in the Access I can add new
records.
Is it possible at all to define the user level security and then access the
database from the Web and if it is how do I do it?
Please help
Denijal