Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

IIS not letting me write to access2k database

paulfppaulfp Member Posts: 13
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

Comments

  • tizigmantizigman Member Posts: 2
    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
    :

Sign In or Register to comment.