My database is MSAccess and i have written ASP code for data entry form. But my Insert query does not work. The syntax is all ok as i wrote same in MSAccess and it worked! Select query works fine. Error is "Updateable query needed". Can somebody help me on this?
Surely your database does not have "Write" permissions. Every database have "Read" "Write" and "Execute" permissions. For insert or update query the "Write" permission needs to be set through your web admin control panel.