update,insert,delete records not working with MS Access

[sagar694]

i am using trial version of Dremaweaver CS3. I have created a table in MS access 2003. I created a ASP VB script page for inserting records in to the databse through Record insertion form wizard. when i am running the application, i am getting the error at MM_editCmd.Execute.

It is throwing an error
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
similar is the case for update,delete also.

Please help me in this issue...
Thanking you,
Sagar

[MikeL7]

I also was once using a trial copy of DW8, and when i tried to make a recordset i would get a similar error, after checking and rechecking i actually called Adobe and they told me you can NOT connect to a db with a trial copy. I was using DW8, but i think your problem might be the same, they said that is the only function not available with a trial copy. I was using ASP VB also and when i bought it i had the ASP pages running.

[betohresSCRN]

HI, the problem is your IIS configuration. If you are using a IIS 5.1 or upper then go to Control Panel->Administrative tools->IIS services-> open the IIS (the first plus sign),open the default machine(second plus sign),find the WEB SITE and next find the default web site and right click the mouse button, go to the properties item, when the screen appear, go to the Default Directory tab and under Default URL enable the user rights and thats all.

[tommylu1999]

Hi,

I am having the same problem not able to delete a record from MS Access. Would you tell me where can I find my IIS control panel?

Thanks.

Tommy,

[powert98]

Chances are that the folder your database is in does not have write permissions. If it is a local server, then you need to find out how to turn them on depending on what OS you are using (Windows 2000, XP, etc.). If you are writing to a database on a hosting company, usually there is a place in the control panel for folder permissions.