Jet Database Engine Error 80040e09
Contents |
a Question Need help? Post your question and get tips & solutions from a community of 418,581 IT Pros & Developers. It's quick & easy. Microsoft JET Database Engine error '80040e09' P: 18 phuc2583 I have a problem with an application I developed with code charge. odbc microsoft access driver operation must use an updateable query Whenever I try to access a table in a database I get the following error: Microsoft JET
Provider Error '80004005' Unspecified Error
Database Engine error '80040e09' Cannot update. Database or object is read-only. Secondly, I find it difficult to use code charge to append/add records from one
Operation Must Use An Updateable Query C#
table(in a grid form) to another(within the same database) Please, If you've come across this problem & have been able to solve it let me know. Regards Hoang Phuc Feb 28 '08 #1 Post Reply Share this Question 2 Replies P: 14
Microsoft Jet Database Engine Error '80004005'
Merlin1857 Hi, You need to make the folder in which your database is stored a writable folder. Access it, right click it and go to the properties option, then access the 'Security' tab access the anonymous users listed (usually the last in the list) and in the Permissions fo USers window below allow Write permissions. Good Luck Feb 28 '08 #2 reply Expert 100+ P: 560 CroCrew Hello phuc2583, The problem does not fall on the permissions of a folder. First, I am assuming that operation must use an updateable query access your database is an Access database. What you need to do is change the permissions on the “file” that is known to be your database on the server. The common ASP environment is setup that every visitor to your website uses the local server user called “IUSR_******”. You can change that if you want or remove it altogether but, for this example I will just use the default user called “IUSR_”. Think of the “IUSR_” as everyone in the world that can see your web server. On your web server there are permissions that can be set on folders and files. These permissions throttle who can read, create, edit, delete, and more to files and folders on the web server. So what you need to do is find the physical location of your database on the web server (don’t open it) and right clicking on the file and change the permissions and give your “IUSR_” modify permissions and you will be set. Giving the “IUSR_” user special permissions like full Control or modify on a folder is not a good thing to do. Restrict permissions and only give out what is needed is the best way to keep your server from the bad guys. Good luck~ Feb 28 '08 #3 reply Message Cancel Changes Post your reply Join Now >> Sign in to post your reply or Sign up for a free account. Similar topics HTTP 500.100 Microsoft Jet database Engine could not open the file.. already.. Microsoft VBScript runtime error '800a0046'
Cannot update. Database or object is read-only If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link microsoft ole db provider for odbc drivers error '80004005' above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View Poll Results: Rate this response Voters 1. You may not vote on this poll Good 0 0% Very Good 1 100.00% Excellent 0 0% No Rating 0 0% Results 1 to 10 of 10 Thread: Cannot update. Database or object is read-only Tweet Thread Tools Show Printable Version Email this https://bytes.com/topic/asp-classic/answers/776361-microsoft-jet-database-engine-error-80040e09 Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-10-2005,07:08 AM #1 DeveloperWorks View Profile View Forum Posts Registered User Join Date Nov 2005 Posts 4 Cannot update. Database or object is read-only Hi, I'm creating an ASP application that adds form content into a Acess database table (VendorTab) After entering data into the Form, on clicking the Submit button, the following error is http://forums.devx.com/showthread.php?147922-Cannot-update-Database-or-object-is-read-only displayed Microsoft JET Database Engine error '80040e09' Cannot update. Database or object is read-only. I checked the folder and the access DB properties and both are assigned Full Control. I'm using the For Each x n request.Form collection to retrieve form data. Any suggestion, work-around appreciated. Thanks Reply With Quote 11-10-2005,10:26 AM #2 pclement View Profile View Forum Posts Registered User Join Date Dec 2003 Posts 2,750 It's almost certainly a permissions issue. I don't know what level of authentication you are using but full access to the folder where the Access database is located is required. These permissions must either be granted to the Anonymous user account (if Anonymous authentication is used) or the impersonated user account(s) (if Basic or Integrated NT authentication is used). Paul ~~~~ Microsoft MVP (Visual Basic) Reply With Quote 11-11-2005,04:48 AM #3 DeveloperWorks View Profile View Forum Posts Registered User Join Date Nov 2005 Posts 4 Thanks for your response, Paul. Full control is assigned to both the folder and mdb file. Infact, my user account is added to the Adminitrator's group. Morevoer, I tried running the application using the administrator login and yet I seem to get the same error. despite trying some of the tips that were available on google, I still
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help https://www.experts-exchange.com/questions/20726293/Microsoft-JET-DB-Engine-error-80040e09.html Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services http://thewinwiki.org/repair-microsoft-jet-database-engine-error-80040e09/ Groups Website Testing Store Headlines Experts Exchange > Questions > Microsoft JET DB Engine error 80040e09 Want to Advertise Here? Solved Microsoft JET DB Engine error 80040e09 Posted on operation must 2003-09-02 ASP 1 Verified Solution 9 Comments 880 Views Last Modified: 2009-07-29 i have these few asp pages.... which simply does form submission and storing of the form input data onto a MS Access DB... everything works perfectly locally, when i'm using the IIS. However when i upload it onto a free webhosting service.. it gives the following operation must use error when i reach my "process.asp" (this process.asp does the opening of the DB, and updating) Microsoft JET DB Engine error 80040e09 Cannot update. DB or object is read-only is there any way to make it not read-only? 0 Question by:veliscorin Facebook Twitter LinkedIn Google LVL 1 Best Solution byhowtodo try this: mstrPath = server.mapPath("SPIS.mdb") Set mCn = Server.CreateObject("ADODB.Connection") 'Connection object mCn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Go to Solution 9 Comments LVL 44 Overall: Level 44 ASP 12 Message Expert Comment by:TimCottee2003-09-02 Hi veliscorin, Not by yourself I would guess. Your DB needs to be in a folder usually on your hosting service which has the appropriate permissions set for read/write access. Some hosting providers such as brinkster allow access databases only in a specific folder. Tim Cottee MCSD, MCDBA, CPIM Brainbench MVP for Visual Basic http://www.brainbench.com Experts-Exchange Advisory Board Member 0 LVL 1 Overall: Level 1 ASP 1 Message Accepted Solution by:howtodo2003-09-02 try this: mstrPath = server.mapPath("SPIS.mdb") Set mCn = Server.CreateObject("ADODB.Connection") 'Connection object mCn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& mstrPath &";P