IIS not letting me write to access2k database

paulfp

I am running Microsoft Windows XP Professional and IIS 5.1

I am making a messageboard application in ASP but when I connect to the Access 2000 database (without a DSN) i get the following error:

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

I am absolutely 101% sure that the code is correct, as I've looked in serveral books and online tutorials, and even downloaded and run examples, and they all give this or a similar error. The .mdb file on my hard disk is NOT, repeat NOT read-only. I feel sure that there must be some permission setting somewhere which is stopping me write to the database. I can extract data from it without any difficulty at all!

I'd be really grateful to anybody that can help me.

Thanks and God bless you

====
paulfp
www.paulfp.co.uk/delirious

tizigman

Did you defined the database through ODBC Data source Administrator? Hope that helps

: I am running Microsoft Windows XP Professional and IIS 5.1
:
: I am making a messageboard application in ASP but when I connect to the Access 2000 database (without a DSN) i get the following error:
:
: [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
:
: I am absolutely 101% sure that the code is correct, as I've looked in serveral books and online tutorials, and even downloaded and run examples, and they all give this or a similar error. The .mdb file on my hard disk is NOT, repeat NOT read-only. I feel sure that there must be some permission setting somewhere which is stopping me write to the database. I can extract data from it without any difficulty at all!
:
: I'd be really grateful to anybody that can help me.
:
: Thanks and God bless you
:
: ====
: paulfp
: www.paulfp.co.uk/delirious
: