Access 2007 Runtime Error 3027
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 00:59:44 GMT by s_hv987 (squid/3.5.20)
Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced
Cannot Update. Database Or Object Is Read-only Access 2007
Search Find All Thanked Posts Go to Page... Thread Tools error 3027 database or object is read only Rating: Display Modes 04-27-2009, 08:10 AM #1 shenty Newly Registered User Join Date: Jun 2007 Posts:
Cannot Update. Database Or Object Is Read-only Excel
117 Thanks: 0 Thanked 0 Times in 0 Posts Error 3027 Cannot Update. Database or object is read-only I have a very strange problem that has appeared on 3 http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother/access-2010-runtime-error-3027/acc42082-e1e2-4971-9bfc-94a3c6ed305e databases. Error 3027. Cannot update. Database or object is read-only. I have checked & changed nothing to do with folder persmissions etc. The 3 databases are independant but similar. All 3 use linked data tables. The error happens in the VBA code rSt.AddNew. I have created a new blank database & imported the necessary forms, tables & queries http://www.access-programmers.co.uk/forums/showthread.php?t=170950 so there are no linked tables and the error is still there. But all these databases used to work !!!! Does anyone have the slightest idea where these errors have suddenly appeared from ? Help would be much appreciated. P.S. My Stripped down DB is attached. Clicking the "Add Record to cows history ---->" causes it. Attached Files error 3027 fixing.zip (141.1 KB, 438 views) shenty View Public Profile Find More Posts by shenty 04-27-2009, 09:18 AM #2 jzwp22 Access Hobbyist Join Date: Mar 2008 Posts: 2,629 Thanks: 0 Thanked 311 Times in 308 Posts Re: Error 3027 Cannot Update. Database or object is read-only The query for the recordset appears to be un-updateable. Since all of the fields you want to add to are in the tblAIRegister, I would use just the table rather than the query. Code: If MsgBox("Add to history ?", vbYesNo, "Add Record") = vbYes Then Set rSt = dbs.OpenRecordset("tblAIRegister") rSt.AddNew rSt!AIDate = Me.AIBullingDate rSt!TAG = Me.txtTAG rSt!AIBull = Me.txtBullName rSt!AIorBull = RecordType r
object is read-only + Ask a Question Need help? Post your question and get tips & https://bytes.com/topic/access/answers/919418-ms-access-err-run-time-error-3027-cannot-update-database-object-read-only solutions from a community of 418,417 IT Pros & Developers. It's http://www.tek-tips.com/viewthread.cfm?qid=1690766 quick & easy. Ms Access Err - Run-time error '3027': Cannot Update. Database or object is read-only P: 14 ritesh272004 Hi, Could you help me with the below code from Ms Access. I am trying to add data to an access table. FE and BE cannot update in the same file. However i get the error as Run-time error '3027': Cannot Update. Database or object is read-only Expand|Select|Wrap|Line Numbers OptionCompareDatabase OptionExplicit PublicDbMainAsdao.Database PublicRsMainAsdao.Recordset PublicSqlMainAsString PrivateSubCommand3_Click() RsMain.AddNew RsMain.Fields("code")=Me.Text4.Value RsMain.Fields("accode")=Me.Text0.Value RsMain.Fields("name")=Me.Text2.Value RsMain.Update EndSub PrivateSubForm_Load() SqlMain="SELECTTable1.accode,Table1.CodeFROMTable1INNERJOINTable2ONTable1.Code=Table2.maincode" SetDbMain=CurrentDb() SetRsMain=DbMain.OpenRecordset(SqlMain) EndSub Oct 13 '11 #1 Post Reply ✓ answered by NeoPa You may database or object find Reasons for a Query to be Non-Updatable helpful in that respect. Good luck :-) Share this Question 8 Replies Expert 5K+ P: 8,394 ADezii It's possible that the Recordset itself is Not Updateable, add a Line of Code (Code Line #7) to the Load() Event to find out for sure: Expand|Select|Wrap|Line Numbers PrivateSubForm_Load() SqlMain="SELECTTable1.accode,Table1.CodeFROMTable1INNERJOINTable2ONTable1.Code=Table2.maincode" SetDbMain=CurrentDb() SetRsMain=DbMain.OpenRecordset(SqlMain) MsgBox"ThisRecordsetis:"&IIf(RsMain.Updatable,"Updateable","NotUpdateable") EndSub Oct 13 '11 #2 reply P: 14 ritesh272004 Yes Adezii I checked with your line of code and you are correct the recordset is not updatable. But i have used this code earlier and have never found such issue. It would be great if you could help to make it updatable. Oct 13 '11 #3 reply Expert Mod 15k+ P: 29,922 NeoPa Let's start by sending you off on a quick detour to When Posting (VBA or SQL) Code. We don't know which line is causing the problem unless you tell us. Now, with that out of the way, it seems to me you have a much
Join INTELLIGENT WORK FORUMSFOR COMPUTER PROFESSIONALS Log In Come Join Us! Are you aComputer / IT professional?Join Tek-Tips Forums! Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Join Us! *Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.Just copy and paste the BBCode HTML Markdown MediaWiki reStructuredText code below into your site. Microsoft: Access Modules (VBA Coding) Forum at Tek-Tips HomeForumsProgrammersDBMS PackagesMicrosoft: Access Modules (VBA Coding) Forum Access 2003 to 2007: Run-time error '3027' Cannot update, Database or object is read-only thread705-1690766 Forum Search FAQs Links MVPs Access 2003 to 2007: Run-time error '3027' Cannot update, Database or object is read-only Access 2003 to 2007: Run-time error '3027' Cannot update, Database or object is read-only DBLoser (MIS) (OP) 14 Aug 12 16:10 I have a database that worked fine in Access 2003. Now that I'm using Access 2007, it gives a run-time 3027 error. It is breaking down on the DoCmd.TransferText line. I've tried this on multiple computers (XP, Win7) and the file is being saved to the C: drive and I have administrative privileges. The MBNAExportSpecification export spec does exist in the MSysIMEXSpecs table. I also did the old jet registry hack to add the .prn extension to the list of exports (worked fine in 2003). Here is the code: CODE --> Private Sub Export_Click() Dim TempFileName As String Me.Form![txtFileName].SetFocus TempFileName = txtFileName.Text DoCmd.TransferText acExportFixed, "MBNAExportSpecification", "