getting .mdb database errors? read this ..

[Neil]

I have had loads of problems trying to WRITE data to my DB, using iis 5.1 on
my local winxp machine, even though permissions were set correctly in iis,
and all the parent dirs.

If you are getting errors such as :

Microsoft JET Database Engine Error ' 80004005'
Unspecified error
&
Microsoft OLE DB Provider for ODBC Drivers error ' 80004005'
[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an
updateable query.

then follow the steps at:
[url]http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115[/url]
then
[url]http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107[/url]

thats finally worked for me, and has solved 6 months of frustration and a
lot of hair pulling.

HOORAH

Neil

[Neil]

Hi Les,
No the DB had read/write permissions. I even added the IUSR_compname to the
administrator group , and it still didnt work.
It all works now thankfully, but i thought i'd pass on those URLs to anyone
who might be experiencing similar problems.
Neil

"Les Matthews" <LesAMatthews@yahoo.com> wrote in message
news:bf6qk0$m2i$1@forums.macromedia.com...

> Is the database marked as "read only"? Does the IUSR... account have write
> priveleges to it?
>
> "Neil" <asdf@asdf.com> wrote in message
> news:bf6p7u$ji0$1@forums.macromedia.com...

> > I have had loads of problems trying to WRITE data to my DB, using iis

5.1

> on

> > my local winxp machine, even though permissions were set correctly in

iis,

> > and all the parent dirs.
> >
> > If you are getting errors such as :
> >
> > Microsoft JET Database Engine Error ' 80004005'
> > Unspecified error
> > &
> > Microsoft OLE DB Provider for ODBC Drivers error ' 80004005'
> > [Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an
> > updateable query.
> >
> > then follow the steps at:
> > [url]http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115[/url]
> > then
> > [url]http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107[/url]
> >
> > thats finally worked for me, and has solved 6 months of frustration and

a

> > lot of hair pulling.
> >
> > HOORAH
> >
> > Neil
> >
> >

>
>