This is a question about connecting to a database and its problems.
I have a friend who has just started developing and she is making a basic site for a company she works for. She has asked me to help her develop in ASP and this will involve connecting to a MS Access database.
The problem is that the site is hosted on Active ISP. Whenever you try to update a record i a database you get the error:
Microsoft JET Database Engine error '80040e09'
Cannot update. Database or object is read-only.
/contactme/contactMeSubmit.asp, line 39
I figured this was a permissions issue as I got an error similar to this on mine and fixed it by giving permissions to everyone through the internet guest account.
That said, her boss who uses - Dare I say it - 'Frontpage' told her to use frontpage along with the database wizard to create the site. When she uploaded to newly created pages along with the database, it worked and she was able to read and write to the database.
I have never used Frontpage because I want to know how to program and gain knowledge not have some wizard do it for me.
Looking at the code that frontpage generates, I haven't got a clue what is going on as it creates some kind of 'WebBot' system - which I believe is a frontpage extension??
I really don't want her to have to use Frontpage to develop her websites as she will never learn the art of programming.
Her boss is not prepared to ask Active ISP to enable permissions through the IUSR account so it looks like she is stuck with having to use frontpage for the interim.
I Find it strange how frontpage can allow you to access and add/update a database but just using normal ado through ASP cannot.
Am I presuming this is a permission problem by mistake?
Can anybody help me out here?