Macro Export error 3027 (but works manually!)
A macro runs the TransferText command with the following arguments:
Transfer Type = Export Fixed Width
Specification Name = B123 (spec name does exist)
Table Name = CPB059
File Name = T:\reports\B123.FIL
Has Field Names = No
When it gets to this point execution stops with error 3027
"Cannot update Object or database is read only".
However, no files or folders are read-only, in fact access is full control.
Also, if I manually export a text file from that table it works
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Up until recently (not exactly sure when) I've been absolutely fine importing text files into Access 97 with the import wizard, where the file extension is .log
Now, every time I do it, I get Error 3027 unable to update as database/object is read only.
if I change the filename to .txt it works, but if I leave it as .log I get that error.
What in the sweet name of Christmas is going on!?!?!?!?!?
Private Sub Command16_Click()
DoCmd.TransferText acExportDelim, "LBTxt Export Specification", "temp", "C:\Test", True </SPAN>
End Sub </SPAN>
and when I run it I get the following:
I get Run- time error '3027'
cannot update. Database or object is read-only.
I also get this on any table that I try. and I get it if I try maken a macro as well.
Now I should point out that the text file does not exist, but this should create it right?
if I manualy do an export I have no problem.
Neither the database or the table is not set to read only so I do not know.
Actually I cannot tell about the table but I did not set anything
I can export it manually, file->export and it exports it fine.
What I want to do is export it when the user clicks on a button. I have created a form with a button "Export".
Private Sub cmdExport_Click()
Dim stDocName As String
stDocName = "rptClientReport"
DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, "c:\Reports\ClientReport.xls"
When I click the "Export" button,
I get error " Run time error: 9.
Subscript out of range"
Why can't I export the report automatically, but I can do it manually. I have already googled the (*^#$(@ out of this error
and still don't have a fix!
Run-time error '3027':
"Cannot update. Database or object is read-only."
Dim varExportSpec As String
Dim varTableName As String
Dim varFileName As String
varExportSpec = "AAtblBankExport Export Specification"
varTableName = "AAtblBankExport"
varFileName = "C:\BankExport\" & varTableName
DoCmd.TransferText acExportDelim, varExportSpec, varTableName, varFileName
MsgBox "Export Successful.", vbOKOnly
Nothing else is open in the DB, just the form that I use to export. I don't have any other files in the folder path I am using
But when I try to use the TransferSpreadsheet macro action or command, it pops up the "Enter Paramter Value" window (same occurs if I use the excel export button and do not select the option "Export Data with Formating and Layout"). I tried to check the apprently wrong expressions but the queries work fine and I guess it is related to the fact that the records are too large. My question is, how can I still use a macro to automate the export? I do not want to do the export manually as I have over 30 queries to export to different excel worksheets.
When I put the folder back on my machine now, however, when I try to open the Access file it says Error 3027: Cannot update. Database or object is read only.
If I try to re-run the install procedure, it says that my operating system is not adequate to install.
Here is a link to the program files (external as max file size is 2mb). Does anyone know how I will be able to get this to work on Windows
I have tried to create a macro that would export all the data from one of my tables to excel , but keep running into an error message saying 'Cannot modify table structure. Another user had the table open'.
Of course I checked that nothing was open, even shuttind down the computer and going straight to the macro, but the error message keeps popping up.
Im not sure how much of difference it will mke but im using office 2003, but my database is in 'Access 2000 file format'.
Can anyone point to me a google result that ive missed, or offer some advice
This works fine, however since this runs daily the size of the excel file increases each time.
If if manually open the excel file and then close it straight away the file size drops from 160 meg to 60meg (as an example).
I was hoping to add another macro command that would just open the excel file and then another to close the file, however I can't seem to find one.