Weird permissions issue

From: Shinz62 (spam_at_mpulsecmms.com)
Date: 02/18/05


Date: Fri, 18 Feb 2005 14:09:12 -0800

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



Relevant Pages

  • Re: Weird permissions issue
    ... Ur I.T. Mate Group ... > I have an ASP application (IIS 5.0 on Win XP Pro) that talks to an Access ... I have recreated the DSN, ...
    (microsoft.public.inetserver.asp.db)
  • Re: dllhost
    ... It's just about 100% pure ASP with com objects. ... DLLHOST goes to 95-100% utilization and stays there indefinitely unless IIS ... > a simple HTML page serve or do they also hung? ...
    (microsoft.public.inetserver.iis)
  • Re: Accessing 32 bit COM components in 64 bit IIS
    ... CGIs, and ASP scripts onto a 64bit machine, and it just works after they ... The most confusing aspect of running 32bit app on a 64bit OS is that you ... System32 access is redirected, etc). ... we will be introducing the ability to configure IIS to run ...
    (microsoft.public.inetserver.iis)
  • Re: ASP Authentication on IIS 6.0 Windows 2003 Server 32bit help please
    ... when an ASP page is executed in IIS? ... site that requires a user to enter their domain account to access the ... the ASP script code ... I find that the .exe runs ...
    (microsoft.public.inetserver.iis.security)
  • Re: Serious problem in using COM in IIS
    ... introduces a "thread affinity" for your ASP session. ... and that's unlikely to be the thread you're on at the time (IIS ... otherwise i will set it to private and persistable ... >> variables defined in my ABC COM ...
    (microsoft.public.vb.general.discussion)