Access97 Error 3027
Contents |
be down. Please try the request again. Your cache administrator is webmaster. Generated Fri, 30 Sep 2016 01:30:48 GMT by s_hv1000 (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... Page 1 of 2 runtime error 3027 database or object is read only 1 2 > Thread Tools Rate Thread Display Modes 12-07-2009, 05:01 AM ms access cannot update. database or object is read-only #1 ailinglew Registered User Join Date: Dec 2009 Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts Cannot update. Database
Vba Error 3027
or object may be read-only Hi All, I have recently converted a database from Access 97 to Access 2007 which used the TransferText command. DoCmd.TransferText acExportDelim, "Testing Export Specification", "Testing", "C:\Testing" & "." & Format(Now(), "yymmddhh") http://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_other/access97-docmdtransferspreadsheet-acexport-gives/7d3a1ddb-9a68-44e0-bc61-11bb69567759 & "08" - which worked fine. However, when I try to run this line of code in Access 2007 I get a message "Cannot update. Database or object may be read-only". Anybody know how to make this work? Thank you. ailinglew View Public Profile Find More Posts by ailinglew 12-07-2009, 06:04 AM #2 RuralGuy AWF VIP Join Date: Jul 2005 Location: @ 8300' in the http://www.access-programmers.co.uk/forums/showthread.php?t=184720 Colorado Rockies Posts: 13,401 Thanks: 2 Thanked 250 Times in 242 Posts Re: Cannot update. Database or object may be read-only Is everything in your Trusted Locations? __________________ (RG for short) aka Allan Bunch Previous MS Access MVP acXP, ac07, ac10, ac13 - WinXP Pro, Win7 Pro, Win10 Pro Please post back to this Forum so all may benefit. Teaching is not filling a bucket but lighting a fire. RuralGuy View Public Profile Find More Posts by RuralGuy 12-07-2009, 08:38 PM #3 ailinglew Registered User Join Date: Dec 2009 Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts Re: Cannot update. Database or object may be read-only Thanks for your reply. Yes, in Trusted Location. I would like to check with you, is that possible to generate output file as Testing.yymmddhh08 (eg: Testing.0912080108) in Access 2007? Actually the same coding use for Access 97 and it is working fine. The error happened after converted into Access 2007. May i know is that Access 2007 does not support for this file type? Thank you. ailinglew View Public Profile Find More Posts by ailinglew 12-07-2009, 08:45 PM #4 boblarson Former Moderator Join Date: Jan 2001 Location: Oregon, USA Posts:
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 Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close https://www.experts-exchange.com/questions/21297312/VB6-Access97-Error-3027-w-DAO.html Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > VB6 Access97 Error 3027 w/DAO Want to Advertise Here? Solved VB6 Access97 Error 3027 w/DAO Posted on 2005-02-01 Visual Basic Classic 1 Verified Solution 4 Comments 931 Views Last Modified: 2008-01-09 FYI: The database and folder are NOT set to read only. I have a database w/4 tables (tried this w/tables both linked and unlinked database or in Access). I am using DAO controls to access them and populate bound text boxes on a form. I look up a record in the master table, then I check its index and look up the associated records in the other three tables. Following are the parameters: Database & tables are currently set in the controls, not at runtime. (This will be changed later.) Where 'dtaControl' substitutes for any of the four data controls, database or object settings that may be relevant are: dtaControl.Read only = True dtaControl.Exclusive = False dtaControl.RecordsetType = Table '<--- wondering if that's the problem.... txtMostFields.Locked = True (have also tried False, though) All browsing occurs without error, but of course the fields are protected against any change. The error crops up when I allow the user to change the data. On clicking cmdEdit the button flips to 'save' mode, all data controls are set to Read Only=False and text boxes Locked = False. When the button is clicked again (for the save) Error 3027 "Database or Object is locked" is generated on the first instance of: dtaControl.Recordset.Edit Following is a stripped down version of the code in question, which does generate the error: Private Sub cmdEdit_Click() If cmdEdit.Caption = "Edit" Then cmdEdit.Caption = "Save" dtaTest.ReadOnly = False 'should unlock here Else cmdEdit.Caption = "Edit" dtaTest.Recordset.Edit '<---- Error happens here dtaTest.Recordset.Update dtaTest.ReadOnly = True End If End Sub I have tried changing all data controls to Read Only = False, but then I get the other bugaboo: The _second_ time I hit any browse button (whether its +/-1 record or 20) I get