Usage Note 39325: The error "Database or object is read-only" occurs when you deport data to .xlsm files
 |  |  |  |
The following error occurs when you attempt to create new macro-enabled .xlsm files using either the EXPORT procedure or the LIBNAME statement:
proc export data=sashelp.class
outfile='c:\sastest\testmacro1.xlsm'
dbms=excel replace;
run;
outfile='c:\sastest\testmacro1.xlsm'
dbms=excel replace;
run;
ERROR: Connect: Cannot update. Database or object is read-only.
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.
The problem occurs because of limitations in the Microsoft Access Connectivity Engine (ACE), which the EXCEL engine uses to create Microsoft Excel files.
To circumvent the problem, create an .xlsm file in Excel first. Then, use SAS® to append the new file to the existing .xlsm file.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to PC Files | Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.21 | 9.2 TS2M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.21 | 9.2 TS2M0 | ||||
| Microsoft Windows XP Professional | 9.21 | 9.2 TS2M0 | ||||
| Windows Vista | 9.21 | 9.2 TS2M0 | ||||
When you try to create new .xlsm files with the EXCEL engine, you receive the error "Database or object is read-only." The problem occurs because of limitations in the Microsoft Access Connectivity Engine, which the EXCEL engine uses.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2010-11-08 13:34:17 |
| Date Created: | 2010-04-12 12:12:49 |