Cannot execute an INSERT INTO .. VALUES..

[George]

When executing a VB.NET Web application to INSERT INTO a
MS ACCESS 2002 <datatable> <fieldnames> and replace the
new fields with Replace(<fieldname>.<value>) for each
field it works fine from
http://localhost:8080/<filename.aspx>. But when I excute
the same identical code from
http://<websitename.com>/filename.aspx I get this msg.
Operation must use an updateable query. The Website is
the default website <wwwroot> and the ACCESS mdb is
located in /wwwroot/db. Whereas the <localhost> is
residing under <wwwroot> in a separate folder and the /db
is a subfolder of that.

 

[Douglas J. Steele]

What permissions do you have on the folder where the MDB exists? The ID that
IIS is running under (usually IUSR_<machinename>) needs Change (RWXD) on
that folder.