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