Web Hosting Talk







View Full Version : How to set data base


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?

Stew
08-22-2002, 05:08 AM
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.