Error 3027 - exporting a table to Excel via a macro

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
 
K

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
 
W

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


.
 
K

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>

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


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top