combs
08-21-2002, 02:01 PM
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?
sounds like the mdb does not have write permissions
archie2
08-22-2002, 01:17 PM
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.