Hi all

This is a stupid problem that I have never seen before and hope to never see again!!!!

When I try to either update or insert a new record into my database I get the following errors:

UPDATE: In the server behaviours in DWMX it says that the recordset specified could not be found in the script. If I preview the page and try to add something it will say that I must use an updateable query.

INSERT: I must use an updatable query.

These errors are driving me crazy as they are all that is stopping me from finishing off this site! I've tried everything - even creating a new page with nothing on it but the data for the insert/update still to no avail!

Can anyone suggest anything??????

HI

What database are you using? Have you hand coded the recordset code etc or are you using DWMX own recordsets.

Graham

Hi there

it's an access 2000 database and i'm using the built in DWMX update/insert behaviours.

Please don't suggest permissions, they are perfect, I have two sites in dreamweaver (different topcis and unrelated sites), one of them does an update/insert quite happily, the other just refuses to do it nicely.

Hi

Are you running on a win2k box using IIS or PWS

Graham

iis 5.0 on Small Business Server

Hi

Well sorry to say, I have experienced a similar problem myself, and anything relating to using an updatable query is related to permissions.

There is a technote on the subject at MSDN and there are also some posts by on 4guysfromrolla.com.

This is only specific to using an access database and giving the IUSR_machinename account permissions to access the database.

I know its not what you wanted to here but it maybe worth just investigating.

Sorry I cant be of more assistance at this stage.

However do keep me posted.

Graham

Thanks Graham, I do appreciate it

I have already investigated the technotes at microsoft as well as 4guysfromrolla and about every other reputable asp site around, i know they all say the same thing but there is nothing they can suggest that I haven't already done.

I will have to keep hunting