Error 3027 - exporting a table to Excel via a macro

[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

 

[Ken Snell]

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

 

[Willis]

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

.

 

[Ken Snell]

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>

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

.