Ms Access Runtime Error 3027
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 20 Oct 2016 17:33:28 GMT by s_nt6 (squid/3.5.20)
Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find All Thanked Posts Go to Page... Thread Tools Rating: Display Modes 04-27-2009, 08:10 cannot update. database or object is read-only excel AM #1 shenty Newly Registered User Join Date: Jun 2007 Posts: 117 Thanks: cannot update. database or object is read-only access 2007 0 Thanked 0 Times in 0 Posts Error 3027 Cannot Update. Database or object is read-only I have a very strange problem microsoft access runtime error '3027' cannot update that has appeared on 3 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 http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother/access-2010-runtime-error-3027/acc42082-e1e2-4971-9bfc-94a3c6ed305e 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 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 http://www.access-programmers.co.uk/forums/showthread.php?t=170950 Record to cows history ---->" causes it. Attached Files error 3027 fixing.zip (141.1 KB, 462 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 rSt!AIBullBreed = Me.Combo26 rSt!Action = Action rSt!Notes = Me.txtNotes rSt.Update End If jzwp22 View Public Profile Find More Posts by jzwp22 04-27-2009, 11:34 AM #3 shenty Newly Registered User Join Date: Jun 2007 Posts: 117 Thanks: 0 Thanked 0 Times in 0 Posts Re: Error 3027 Cannot Update. Database or object is read-only you hit the nail on the head there mate......coincidently i figured that out about an hour ago before realising you posted. i noticed the query was unupdateable because of the animal register table and linked field in the q
here for a quick overview of the site Help Center Detailed answers to any http://stackoverflow.com/questions/20431018/recordset-update-database-or-object-is-read-only questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more http://www.tek-tips.com/viewthread.cfm?qid=1690766 about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack cannot update Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Recordset.Update Database or Object is read-only up vote 4 down vote favorite Not sure this is going to work in the specifics I intend. The scenario is the text cannot update. database boxes are populated with data from a table, and the user edits the records and clicks a button to save. Dim cdb As DAO.Database, rstEdit As DAO.Recordset Set cdb = CurrentDb DataValues = "SELECT * FROM Companies, Link_Table WHERE Companies.CompanyID = " & SelectedValue & ";" Set rstEdit = CurrentDb.OpenRecordset(DataValues, dbOpenSnapshot) With rstEdit OldCompanyName = !CompanyName OldCompanyDescription = !Description OldFriendlyName = !FriendlyName OldAddressLine1 = !AddressLine1 OldAddressLine2 = !AddressLine2 OldAddressLine3 = !AddressLine3 OldTown = !Town OldPostcode = !AddressPostcode OldCounty = !AddressCounty OldMainTelephone = !MainTelephone OldMainEmail = !MainEmail OldWeb = !WebAddress 'Not sure this is necessary. It was quoted in the example, but unsure why? ^' !CompanyName = NewCompanyName !Description = NewCompanyDescription !FriendlyName = NewFriendlyName !AddressLine1 = NewAddressLine1 !AddressLine2 = NewAddressLine2 !AddressLine3 = NewAddressLine3 !Town = NewTown !AddressPostcode = NewPostcode !AddressCounty = NewCounty !MainTelephone = NewMainTelephone !MainEmail = NewMainEmail !WebAddress = NewWeb .Update End With However, on clicking the save button, it errors stating
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", "ExportTable", TempFileName Me.Form![txtFileName].SetFocus MsgBox ("Successfully exported the file " & txtFileName.Text) Me.Form![txtFileName].SetFocus End Sub Private Sub Form_Load() Dim DateToFilename As String DateToFilename = "C:\" & Format(Date, "mmddyyyy") Me.Form![txtFileName].SetFocus txtFileName.Text = DateToFilename & ".prn" End Sub RE: Access 2003 to 2007: Run-time error '3027' Cannot update, Database or object is read-only genomon (Programmer) 14 Aug 12 17:01 Try