Unanswered: INSERT records into MsAcess using vbscript
I have tried a few different things to get my website to insert a simple record into my database using the following code:
% @LANGUAGE ="VBSCRIPT" %>
Set Conn = server.CreateObject("ADODB.connection")
sql = "insert into users(User_Name,Passwrd) values('Jenkat', '123456')"
set rs = Conn.execute(sql)
I have also changed the security settings for the database in IIS, so i was wondering what i was doing wrong because the following error is displayed:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/fffan/create.asp, line 7