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 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/