Can not update database on local machine

[Guest_imported]

Hi

After updating from win98 to XP Pro I'm unable to update a database on my local machine. This is the error I get...

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object
is read-only.
/gdp/processnewsletter.asp, line 41

Unsurprisingly line 41 is ...
objRec.Update

Is there a setting I can change? I've searched for this error on the MS site and got this...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518

But none of the errors were the same I'm getting.

Any ideas?

TIA
Paul

 

[GaryC123]

Check in Options, under Advanced tab that the db is set to shared access and not exclusive.

 

[FesterSXS]

do your windows permissions at the location of the database permit you to update the file? Tony

http://www.phoenix-paints.co.uk/portfolio

 

[Guest_imported]

thanks guys...appreciated

I sorted it out by editing the directory security property in iis. Unchecking the anonymous access checkbox did the trick. No idea why but it seems to have solved the problem.

Paul