Unable to Write Records to MS Access

[JGP]

I inherited a small project tracking app, and after
migrating the app to my machine, started receiving the
following error message....

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/vzr/init_add.asp, line 115


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
CLR 1.0.3705)

Page:
POST 1233 bytes to /vzr/init_add.asp



The relevant code block:

r1.Update
init_id = r1("init_id")
r1.Close

Response.Redirect "init_detail.asp?init_id=" &
init_id
else
%


Any help would be greatly appreciated.

[Ken Schaefer]

NTFS permissions...

Anonymous User Account (IUSR_<machinename>, or whatever account is urnning
the .asp page) needs NTFS Read (RX) permissions to the folder that the
Access file is in *plus* Creator/Owner* should have Full Control.
Additionally, the same permissions need to be applied to the c:\winnt\temp
folder so that Jet can write it's temporary working files.

Cheers
Ken


"JGP" <jpapadia3@yahoo.com> wrote in message
news:0ead01c36b64$fa247220$a001280a@phx.gbl...
: I inherited a small project tracking app, and after
: migrating the app to my machine, started receiving the
: following error message....
:
: Error Type:
: Microsoft JET Database Engine (0x80004005)
: Operation must use an updateable query.
: /vzr/init_add.asp, line 115
:
:
: Browser Type:
: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
: CLR 1.0.3705)
:
: Page:
: POST 1233 bytes to /vzr/init_add.asp
:
:
:
: The relevant code block:
:
: r1.Update
: init_id = r1("init_id")
: r1.Close
:
: Response.Redirect "init_detail.asp?init_id=" &
: init_id
: else
: %
:
:
: Any help would be greatly appreciated.

[Aaron Bertrand - MVP]

[url]http://www.aspfaq.com/2062[/url]
[url]http://www.aspfaq.com/2009[/url]



"JGP" <jpapadia3@yahoo.com> wrote in message
news:0ead01c36b64$fa247220$a001280a@phx.gbl...

> I inherited a small project tracking app, and after
> migrating the app to my machine, started receiving the
> following error message....
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> Operation must use an updateable query.
> /vzr/init_add.asp, line 115
>
>
> Browser Type:
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET
> CLR 1.0.3705)
>
> Page:
> POST 1233 bytes to /vzr/init_add.asp
>
>
>
> The relevant code block:
>
> r1.Update
> init_id = r1("init_id")
> r1.Close
>
> Response.Redirect "init_detail.asp?init_id=" &
> init_id
> else
> %
>
>
> Any help would be greatly appreciated.