Access97 Error 3027 Transfertext

If I do a DoCmd.TransferText to export from a query and set the export file name cannot update. database or object is read-only access to xxxxx.xls I get "Error 3027, Can't update. Database or

Cannot Update Database Or Object Is Read Only Access 2010

object is read only.". The full line of code is: DoCmd.TransferText acExportDelim, "OpenAccountsExportInvoices", "qryOpenAccoun tsExportTable", sPathname, False sPathname is a string variable containing a full pathname including a filename ending in ".xls". If I change this to ".csv" it exports OK. I am running WinXP Pro. The error occurs with any version of Access (Access97, 2000 or XP). It does not occur on Win98 or Win2K. Anyone seen this before? I can't find anything in the knowledge base about it. Thanks, Bob Bob Tindall, Jul 2, 2003 #1 Advertisements Joe Fallon Guest Check out the following KB articles for an explanation, and how to get around it: ACC97: "Can't Update. Database or Object Is Read-only" Error Message When You Import Files http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q247861 ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When You Import Files http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q245407 ACC2000: How to Import a Text File That Has an Extension That Access Does Not Recognize (Q306144) http://support.microsoft.com/default.aspx?scid=kb;EN-GB;q306144 -- Joe Fallon Access MVP "Bob Tindall" <> wrote in message news:087b01c3408a$90035d70$... > If I do a DoCmd.TransferText to export from a query and > set the export file name to xxxxx.xls I get "Error 3027, > Can't update. Database or object is read only.". The full > line of code is: > > DoCmd.TransferText > acExportDelim, "OpenAccountsExportInvoices", "qryOpenAccoun > tsExportTable", sPathname, False > > sPathname is a string variable containing a full pathname > including a filename ending in ".xls". If I change this > to ".csv" it exports OK. > > I am running WinXP Pro. The error occurs with any version

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 Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > How to resolve the error "error 3027 Cannot update. Database or object is read-only. when I try and export a query to a doc from Access 2003? Want http://www.pcreview.co.uk/threads/transfertext-in-xls-causes-error-3027.1667237/ to Advertise Here? Solved How to resolve the error "error 3027 Cannot update. Database or object is read-only. when I try and export a query to a doc from Access 2003? Posted on 2012-10-10 MS Access 1 Verified Solution 7 Comments 1,636 Views Last Modified: 2012-10-11 I am developing an Access 2003 application and I want to transfer a query https://www.experts-exchange.com/questions/27895989/How-to-resolve-the-error-error-3027-Cannot-update-Database-or-object-is-read-only-when-I-try-and-export-a-query-to-a-doc-from-Access-2003.html to a word doc. I tried using the following code in my VBA code: ExportedFile1 = CurrentProject.Path & "\reports\BCINewOISrtByBk" & ".doc" DoCmd.TransferText acExportDelim, , "qryNewBCIOISrtByBk", ExportedFile1, True, "" And the result is the following error message: error# 3027 Cannot update. Database or object is read-only. 0 Question by:zimmer9 Facebook Twitter LinkedIn Google LVL 74 Active 6 days ago Best Solution byJeffrey Coachman Sure, but this goes beyond the original question here, because you would need to set vba references to the Word Object Model Go to Solution 7 Comments LVL 11 Overall: Level 11 Message Expert Comment by:Paul S2012-10-10 TransferText Method http://msdn.microsoft.com/en-us/library/office/bb214141(v=office.12).aspx DoCmd.TransferText acExportDelim, "Standard Output", _ "External Report", "C:\Txtfiles\April.doc" make sure the target folder exists and that you have read/write access. 0 Message Active 2 days ago Author Comment by:zimmer92012-10-10 A string expression that's the name of the Microsoft Access table you want to import text data to, export text data from, or link text data to, or the Microsoft Access quer

or object is read-only (Error 3027) Message #1 by "Stefan ROBERT" on Tue, 19 Jun 2001 00:44:14 I encounter the following problem with http://p2p.wrox.com/archives/access/2001-06/41.php an Access Application : 1. An Access program run normally on Compaq http://www.bigresource.com/MS_ACCESS-Runtime-error-3027-Cannot-update-Database-or-Object-is-Read-only-6Qs76xPD.html Desktpro Pentium Pro workstations under WindowsNT SR-3 and Access97 SR-2 Not secured, the programs and the data are not read-only. 2. Now that we replace the Compaq Pc with IBM PL300 Pentium III 700 MHz under WinNT SR-5 and still Access97 SR-2 we receive everytime the following error message database or (Can't update. Database or object is read-only (Error 3027) on the Access statement : DoCmd.TransferText acExport, SpecName, Tablename, Filename and the resulting output sequential file is not created. We do not change anything to the Access97 coding. It is the same pgm. The Access database with the programs and data is the same. The Access97 program is located on the C: database or object drive. The Access97 database with data is located on the Server. We made the test with the same user (same WinNT profile). The Access programs and data are not secured (not read-only). Question : what's read-only ? - the database were we do de extract from ? - the database were we put the result of the extract (query) - the file were we want to store the result of the TransferText (we check the WinNT permissions - there is no problem). For wich object is the error code 3027 in this statement ? How can I've more information about this error code ? For example, the name of the object that is read-only ? Can you suggest a track were we can look ahead and make tests ? We are testing for more than 2 weeks on this problem. Stefan from Belgium E-mail : Stefan.Robert@a... Message #2 by "Karl Kuellmer" on Thu, 21 Jun 2001 00:53:31 Ok, I experienced a very similar situation, but in Access 2000. After applying Service pack to NT, TransferText started behaving differently. Under

a button. Below is the code. Where the code is in bold that is when the runtime error happens. If i export the code manually by right click on the query > Export then this works, but for some reason by clicking on the button will not work. Private Sub cmdExport_Click() Dim sExportFilePath As String sExportFilePath = DLookup("[DateExportLocation]", "tblSettings", "[ID]=1") ' Path if file to be exported DoCmd.OpenQuery "qryUpDateTransmissionDateAndTime", acViewNormal, acEdit ' Update dates time DoCmd.TransferText acExportDelim, "ExportFile", "qryExportFile", sExportFilePath End Sub I appreciate your help View Replies Similar Messages: Runtime Error 3027 Cannot Update, Database Or Object Is Read-only Run Error: 3027 Object Read-only General :: Cannot Update - Database Or Object Is Read-only Cannot Update. Database Or Object Is Read-only - User Rights?! "Cannot Update. Database Or Object Is Read-only" On Import. Modules & VBA :: RunTime Error 424 - Object Required Queries :: Runtime Error 429 - ActiveX Component Can't Create Object General :: Database Or Object Is Read Only? Modules & VBA :: Object Read Only And Type Mismatch Error For Serial Number Runtime Error When Trying To Clear An Unbound Cbo After Update Update Query Giving Me A Runtime Error 3061 Error 3027 When Importing Text File? Runtime Error:3734. The Database Has Been Placed.... Error "The Database 'Name' Is Read-only? General :: Update Query Has Error 424 Object Required General :: Exporting Queries - Database Is Read Only Error Message? General :: No Permission To Open Database Object Error Users_Database Or Object Read Only Include Object Library With Runtime. Access Error 3027 When Using VBA To Append Table To A Linked Table? Forms :: Exclude Object From Read Only? Active X Cant Create Object In Access2000 Runtime Error: Member Already Exists In An Object Module From Which This Object Module Derive SQL ERROR - Runtime Error 3061 - RunTime Error 75 - HELP !!! ADVERTISEMENT Runtime Error 3027 Cannot Update, Database Or Object Is Read-only Dec 20, 2006 I create a front end and back end that resides on the lan. Front has everything besides the table which resides on the back end. Front ends table are linked to the backend. I have two computer that i am testin