Weird permissions issue

Howdy Experts!

I have an ASP application (IIS 5.0 on Win XP Pro) that talks to an Access
2003 database via an ODBC DSN. The app works great in a hundred or more
installations. However, I have one customer that when they try to write
anything (it reads data just fine), the ASP page gives this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
query.
/rwrapp.asp, line 302

For the life of me, I can't figure it out. The volume the DB is on is NOT
NTFS, it is FAT. I added IUSR_MachineName to the Administrators group
even...and still no luck. I have recreated the DSN, checked for 'read only',
or 'exclusive' in both the DB and the DSN. I have transferred the DB to
another workstation, and it worked there. I have reinstalled the ASP pages.
I have restarted IIS. I have restarted the PC. I have also re-installed
MDAC 2.6.

HEEEEEELLLLLLLLLPPPPPP!!!!!

-Shinz62

Re: Weird permissions issue

http://aspfaq.com/show.asp?id=2062

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

"Shinz62" wrote in message
news:18881E57-8EA0-46BA-9F41-B0C602F8881B@microsoft.com...
> Howdy Experts!
>
> I have an ASP application (IIS 5.0 on Win XP Pro) that talks to an Access
> 2003 database via an ODBC DSN. The app works great in a hundred or more
> installations. However, I have one customer that when they try to write
> anything (it reads data just fine), the ASP page gives this error:
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> query.
> /rwrapp.asp, line 302
>
> For the life of me, I can't figure it out. The volume the DB is on is NOT
> NTFS, it is FAT. I added IUSR_MachineName to the Administrators group
> even...and still no luck. I have recreated the DSN, checked for 'read
only',
> or 'exclusive' in both the DB and the DSN. I have transferred the DB to
> another workstation, and it worked there. I have reinstalled the ASP
pages.
> I have restarted IIS. I have restarted the PC. I have also re-installed
> MDAC 2.6.
>
> HEEEEEELLLLLLLLLPPPPPP!!!!!
>
> -Shinz62

Re: Weird permissions issue

No dice on that link. All the things they suggest are things I have already
tried. Any other advice out there?!?



"Steven Burn" wrote:

> http://aspfaq.com/show.asp?id=2062
>
> --
> Regards
>
> Steven Burn
> Ur I.T. Mate Group
> www.it-mate.co.uk
>
> Keeping it FREE!
>
> "Shinz62" wrote in message
> news:18881E57-8EA0-46BA-9F41-B0C602F8881B@microsoft.com...
> > Howdy Experts!
> >
> > I have an ASP application (IIS 5.0 on Win XP Pro) that talks to an Access
> > 2003 database via an ODBC DSN. The app works great in a hundred or more
> > installations. However, I have one customer that when they try to write
> > anything (it reads data just fine), the ASP page gives this error:
> >
> > Error Type:
> > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> > [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> > query.
> > /rwrapp.asp, line 302
> >
> > For the life of me, I can't figure it out. The volume the DB is on is NOT
> > NTFS, it is FAT. I added IUSR_MachineName to the Administrators group
> > even...and still no luck. I have recreated the DSN, checked for 'read
> only',
> > or 'exclusive' in both the DB and the DSN. I have transferred the DB to
> > another workstation, and it worked there. I have reinstalled the ASP
> pages.
> > I have restarted IIS. I have restarted the PC. I have also re-installed
> > MDAC 2.6.
> >
> > HEEEEEELLLLLLLLLPPPPPP!!!!!
> >
> > -Shinz62
>
>
>

Re: Weird permissions issue

"Shinz62" wrote in message
news:2E1C84AF-77C9-4D7A-B2CB-474075C0A21C@microsoft.com...
> No dice on that link. All the things they suggest are things I have
> already
> tried. Any other advice out there?!?
>

>> > I have restarted IIS. I have restarted the PC. I have also
>> > re-installed
>> > MDAC 2.6.

The Jet database drivers are not included in MDAC (since 2.5 IIRC). Although
I would have also said it is a permissions issue, it is worth installing the
latest Jet drivers

http://support.microsoft.com/?kbid=829558

Also, don't use DSN. Your connection string should be something like:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\yourdb.mdb;Persist
Security Info=False

database file>

--
John Blessing

http://www.LbeHelpdesk.com - Help Desk software priced to suit all
businesses
http://www.room-booking-software.com - Schedule rooms & equipment bookings
for your meeting/class over the web.
http://www.lbetoolbox.com - Remove Duplicates from MS Outlook

Re: Weird permissions issue

On Fri, 25 Feb 2005 20:20:40 -0000, "John Blessing"
wrote:

>"Shinz62" wrote in message
>news:2E1C84AF-77C9-4D7A-B2CB-474075C0A21C@microsoft.com...
>> No dice on that link. All the things they suggest are things I have
>> already
>> tried. Any other advice out there?!?
>>
>
>>> > I have restarted IIS. I have restarted the PC. I have also
>>> > re-installed
>>> > MDAC 2.6.
>
>The Jet database drivers are not included in MDAC (since 2.5 IIRC). Although
>I would have also said it is a permissions issue, it is worth installing the
>latest Jet drivers
>
>http://support.microsoft.com/?kbid=829558
>
>Also, don't use DSN. Your connection string should be something like:
>
>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\yourdb.mdb;Persist
>Security Info=False

Mine has a DBQ= instead of Data Source=.
Is that important?

PJ


>
> >database file>

Re: Weird permissions issue

"Duffaukid" wrote in message
news:5u1a21l30nsnl0s21o6lor7nb5a7lfr4hh@4ax.com...
> On Fri, 25 Feb 2005 20:20:40 -0000, "John Blessing"
> wrote:
>
>>"Shinz62" wrote in message
>>news:2E1C84AF-77C9-4D7A-B2CB-474075C0A21C@microsoft.com...
>>> No dice on that link. All the things they suggest are things I have
>>> already
>>> tried. Any other advice out there?!?
>>>
>>
>>>> > I have restarted IIS. I have restarted the PC. I have also
>>>> > re-installed
>>>> > MDAC 2.6.
>>
>>The Jet database drivers are not included in MDAC (since 2.5 IIRC).
>>Although
>>I would have also said it is a permissions issue, it is worth installing
>>the
>>latest Jet drivers
>>
>>http://support.microsoft.com/?kbid=829558
>>
>>Also, don't use DSN. Your connection string should be something like:
>>
>>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\yourdb.mdb;Persist
>>Security Info=False
>
> Mine has a DBQ= instead of Data Source=.
> Is that important?
>

Try it and see !

--
John Blessing