Error 3027 - exporting a table to Excel via a macro

  • Thread starter Thread starter Willis
  • Start date Start date
W

Willis

I get an error message ("3027 - Cannot update. Database or
object is read-only") when trying to export a table to an
Excel spreadsheet. I also tried to export the table using
Visual Basic, but get the same error. There is not
already a file of the same name.

It works to select the table and use Tools>Office
Links>Analyze It with MS Excel.

Any suggestions??? ...Willis
 
There are many reasons why you can get this error, and as you have given us
almost no details or info, here is some generic info for you:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb;[LN];245407

ACC2002: "Cannot Update. Database or Object Is Read-Only" Error When You
Convert an Uncompiled, Read-only Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;295200

"Cannot Update. Database or Object Is Read-only" Error When You Use
TransferSpreadsheet
http://support.microsoft.com/default.aspx?scid=kb;en-us;304146

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb;en-us;245407

ACC2000: Error When You Export an Object to a Path and File Name Longer Than
64 Characters
http://support.microsoft.com/default.aspx?scid=kb;en-us;250459
 
Ken, Since the message was in "Access>Macros" I assumed
that you realized that I was trying to use a Macro to
export to an Excel Spreadsheet as was part of my message.
Anyway I looked up Article 304146 which states that the
resolution to the problem was to not surround the path
with quotation marks. That still wasn't my problem as I
was not using quote marks. I did further testing and was
only able to use a path that did not exceed two levels
deep. My original path was C:\Documents and
Settings\aaaa\bbbb\cccc\dddd\eeee.xls. I got it to work
by using only C:\Documents and Settings\aaaa\eeee.xls

Thanks for leading me to the article. ...Willis
-----Original Message-----
There are many reasons why you can get this error, and as you have given us
almost no details or info, here is some generic info for you:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb; [LN];245407

ACC2002: "Cannot Update. Database or Object Is Read-Only" Error When You
Convert an Uncompiled, Read-only Database
http://support.microsoft.com/default.aspx?scid=kb;en- us;295200

"Cannot Update. Database or Object Is Read-only" Error When You Use
TransferSpreadsheet
http://support.microsoft.com/default.aspx?scid=kb;en- us;304146

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb;en- us;245407

ACC2000: Error When You Export an Object to a Path and File Name Longer Than
64 Characters
http://support.microsoft.com/default.aspx?scid=kb;en- us;250459


--
Ken Snell
<MS ACCESS MVP>


I get an error message ("3027 - Cannot update. Database or
object is read-only") when trying to export a table to an
Excel spreadsheet. I also tried to export the table using
Visual Basic, but get the same error. There is not
already a file of the same name.

It works to select the table and use Tools>Office
Links>Analyze It with MS Excel.

Any suggestions??? ...Willis
Click to expand...


.
Click to expand...
 
Yes, I assumed that you were trying to use a macro for the export. That has
no bearing, though, on the likely causes for the error that you're seeing,
and thus I pointed you to the KB articles to see if any of them contained
the answer that you needed. Looks as if the "64-character" limitation is the
source of the error that you'd been getting...glad you've found the
solution.

--
Ken Snell
<MS ACCESS MVP>

Willis said:
Ken, Since the message was in "Access>Macros" I assumed
that you realized that I was trying to use a Macro to
export to an Excel Spreadsheet as was part of my message.
Anyway I looked up Article 304146 which states that the
resolution to the problem was to not surround the path
with quotation marks. That still wasn't my problem as I
was not using quote marks. I did further testing and was
only able to use a path that did not exceed two levels
deep. My original path was C:\Documents and
Settings\aaaa\bbbb\cccc\dddd\eeee.xls. I got it to work
by using only C:\Documents and Settings\aaaa\eeee.xls

Thanks for leading me to the article. ...Willis
-----Original Message-----
There are many reasons why you can get this error, and as you have given us
almost no details or info, here is some generic info for you:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb; [LN];245407

ACC2002: "Cannot Update. Database or Object Is Read-Only" Error When You
Convert an Uncompiled, Read-only Database
http://support.microsoft.com/default.aspx?scid=kb;en- us;295200

"Cannot Update. Database or Object Is Read-only" Error When You Use
TransferSpreadsheet
http://support.microsoft.com/default.aspx?scid=kb;en- us;304146

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import or Export Files
http://support.microsoft.com/default.aspx?scid=kb;en- us;245407

ACC2000: Error When You Export an Object to a Path and File Name Longer Than
64 Characters
http://support.microsoft.com/default.aspx?scid=kb;en- us;250459


--
Ken Snell
<MS ACCESS MVP>


I get an error message ("3027 - Cannot update. Database or
object is read-only") when trying to export a table to an
Excel spreadsheet. I also tried to export the table using
Visual Basic, but get the same error. There is not
already a file of the same name.

It works to select the table and use Tools>Office
Links>Analyze It with MS Excel.

Any suggestions??? ...Willis
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top