Access Runtime Error 3027
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Thu, 29 Sep 2016 17:11:10 GMT by s_hv972 (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
Run-time Error '3027' Cannot Update. Database Or Object Is Read-only
Tools Rating: Display Modes 04-27-2009, 08:10 AM #1 shenty Newly Registered User cannot update. database or object is read-only access 2010 Join Date: Jun 2007 Posts: 117 Thanks: 0 Thanked 0 Times in 0 Posts Error 3027 Cannot Update. Database or
Cannot Update. Database Or Object Is Read-only Access 2013
object is read-only I have a very strange problem 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 http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_winother/access-2010-runtime-error-3027/acc42082-e1e2-4971-9bfc-94a3c6ed305e 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 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 http://www.access-programmers.co.uk/forums/showthread.php?t=170950 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 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 th
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 above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 http://www.dbforums.com/showthread.php?1669870-How-do-I-fix-Run-Time-Error-3027 to 7 of 7 Thread: How do I fix Run-Time Error 3027? Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 09-09-11,09:32 #1 Ari Potter View https://www.programmersheaven.com/discussion/173206/runtime-error-3027-cant-update-database-or-object-is-read-only Profile View Forum Posts Registered User Join Date Sep 2011 Posts 19 Unanswered: How do I fix Run-Time Error 3027? Good Morning, One of my databases is experiencing the "gremlin effect". It was working fine yesterday until this morning. For some reason the cannot update backend of my database is in a "read-only" mode. The database is not locked, and no one is in it. (except right now I am because I'm trying to figure out stuff). What happens is we have users who need to submit requests to a central database. The On-Click event of the submittal form opens up the backend table, and then the code adds the request to the table. The users who work off of this information are in a separate database. Their database is totally time error 3027 locked down right now. No one can type in it, alter it, etc. I can go in and alter code, but it doesn't stop the fact that no one can work on their requests right now. This is the code that opens the table to submit the information Code: Dim rsRequest As Object Set rsRequest = CurrentDb.OpenRecordset("Split-Merge - Request table") rsRequest.AddNew There are more lines of code after this but this is where the debugger stops it at the "rsRequest.AddNew" line, and I get the Run-Time Error 3027. Any ideas as to how I'm supposed to unlock this table that doesn't appear to be locked? Thanks bunches!! Ari Reply With Quote 09-09-11,10:20 #2 Sinndho View Profile View Forum Posts Moderator Join Date Mar 2009 Posts 5,440 Provided Answers: 14 1. Backup Database (in the File Menu). This will create a new compacted database that hopefully should not be locked. Check and if it works, discard the original database and rename the backup. 2. Compact and Repair (in the Tools Menu). This basically performs the same operations as a backup, but does not produce a new file (a temporary file is used, that is deleted at the end of the operation). I prefer the first method: I find the Compact and Repair operation a little risky. 3. If both methods above do not work, create a new database and import all the tables from the back-end into it, check and if it works, discard the original database and rename the new database. Have a nice day! Reply Wit
Of... Categories 141.8K All Categories104.8K Programming Languages 6.4K Assembler Developer 1.9K Basic 39.9K C and C++ 4.3K C# 7.9K Delphi and Kylix 4 Haskell 9.6K Java 4.1K Pascal 1.3K Perl 2K PHP 523 Python 37 Ruby 4.4K VB.NET 1.6K VBA 20.8K Visual Basic 2.6K Game programming 312 Console programming 89 DirectX Game dev 1 Minecraft 110 Newbie Game Programmers 2 Oculus Rift 8.9K Applications 1.8K Computer Graphics 732 Computer Hardware 3.5K Database & SQL 525 Electronics development 1.6K Matlab 628 Sound & Music 257 XML Development 3.3K Classifieds 198 Co-operative Projects 189 For sale 189 FreeLance Software City 1.9K Jobs Available 601 Jobs Wanted 201 Wanted 2.9K Microsoft .NET 1.7K ASP.NET 1.1K .NET General 3.3K Miscellaneous 5 Join the Team 0 User Profiles 354 Comments on this site 62 Computer Emulators 2.1K General programming 187 New programming languages 612 Off topic board 177 Mobile & Wireless 51 Android 124 Palm Pilot 335 Multimedia 151 Demo programming 184 MP3 programming 6.9K Operating Systems & Platforms 0 Bash scripts 22 Cloud Computing 365 Embedded / RTOS 53 FreeBSD 1.7K LINUX programming 368 MS-DOS 0 Shell scripting 320 Windows CE & Pocket PC 4.1K Windows programming 906 Software Development 408 Algorithms 68 Object Orientation 89 Project Management 90 Quality & Testing 250 Security 7.6K WEB-Development 1.8K Active Server Pages 61 AJAX 2 Bootstrap Themes 55 CGI Development 19 ColdFusion 224 Flash development 1.4K HTML & WEB-Design 1.4K Internet Development 2.2K JavaScript 35 JQuery 290 WEB Servers 152 WEB-Services / SOAP Runtime error 3027: Can't Update:Database or object is read only gaddu Member Posts: 5 February 2003 in Visual Basic I connected visual basic 5 and oracle. I am trying to addnew records in the database. I used the code as follows:Private Sub cmdAdd_Click()Set wst = CreateWorkspace("ODBCworkspace", "xxx", "xxx", dbUseODBC)Set db = wst.OpenDatabase("oracle", dbDriverNoPrompt, False, "ODBC;DATABASE=oracle;UID=xxx;PWD=xxx;DSN=oracle;")Set rs = db.OpenRecordset("address_table", dbOpenDynaset)rs.MoveLastrs.AddNewrs!first_name = txtfirst_name.Textrs.Updaters.Closedb.Closewst.CloseEnd SubWhen I omitted the workspace object and used only database and recordset object the code works fine...Pls help... 0 · Share on Facebook Comments jeffreyhamby Member Posts: 175 February 2003 [italic]: Private Sub cmdAdd_Click(): Set wst = CreateWorkspace("ODBCwo