Sorry for the delay in responding. End of the year projects pile up quick.
Running the command gives me these permissions on the file:
BUILTIN\Administrators:F
Everyone:F
NT AUTHORITY\INTERACTIVE:R
JDCWEBD02\IUSR_JDCWEBD02X:F
JDCWEBD02\IWAM_JDCWEBD02X:R
NT AUTHORITY\NETWORK:F
NT AUTHORITY\NETWORK SERVICE:F
JDCWEBD02\OWS_3987042754_admin:F
NT AUTHORITY\SYSTEM:F
BUILTIN\Users:R
Steve Radich <[EMAIL PROTECTED]> wrote: As you've seen in your research,
usually this is a permissions issue.
The only two things I can think of are:
1) deny permissions will override allows, i.e. if a group is
denied
2) If you are doing ASPNET then is it running as ASPNET user or
something else? Does ASPNET user have permission?
In your reply probably the best thing is to show us the permissions,
i.e. from a command prompt do "cacls c:\inetpub\wwwroot\file.xls" and
"cacls c:\inetpub\wwwroot" - Of course substitute your path for
c:\inetpub\wwwroot.
Steve Radich - http://www.ASPDeveloper.Net - www.VirtualServerFAQ.com
BitShop, Inc. - http://www.bitshop.com - Managed Servers, Colocation,
Troubleshooting, Development and Perf Monitoring (C#,VB,ASP,SQL)
Dedicated Windows 2003 Starting at $49/month
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of guruhawks
Sent: Monday, December 19, 2005 9:01 AM
To: [email protected]
Subject: [AspNetAnyQuestionIsOk] OleDbException (0x80004005): Operation
must use an updateable query
I am getting this error message when trying to insert or update data
in an EXCEL worksheet via ASP.NET/C#.
OleDbException (0x80004005): Operation must use an updateable query
I can read the data and bind it to a data grid fine . Everywhere I
have looked online points at this being a security issue but everyone
is working with Access DB's. I even searched the forums here to get
information and no such luck. Since I am the admin of the server
(2003) I have given everything that connects to it modify rights
(NETWORK SERVICES, INTERNET GUEST ACCOUNT, etc, etc) you name it I
gave them rights (folder and file) and even added a few accounts that
weren't there to see if that would help. Nothing I do will allow me
to insert or update data in the Excel worksheet I keep getting that
error. I can post code if needed. I am at wits end here and if
anyone has any insight or needs more information let me know. Thank
you.
Yahoo! Groups Links
SPONSORED LINKS
Basic programming language
Computer programming languages
Programming languages
Java programming language
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "AspNetAnyQuestionIsOk" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Yahoo! for Good - Make a difference this year.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
