Connecting with ASP to MS Access database protected with user_level security
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
<%@ LANGUAGE = "VBScript" %>
'Create ADO Connection object
strDSN = "FILEDSN=Kino.dsn"
Set cn = Server.CreateObject("ADODB.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 & "')"
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
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?
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL