Usage Note 52228: Access violations and syntax errors occur when you export data to Microsoft Access files using the ACCESSCS driver
 |  |  |  |
Exporting to Microsoft Access tables and using the ACCESSCS driver can generate syntax errors or access violations as shown below:
NOTE: Data file CNT_2012.ALL_2012_ICD9_PROC_CNT.DATA is in a format that is native to
another host, or the file encoding does not match the session encoding. Cross
Environment Data Access will be used, which might require additional CPU resources and
might reduce performance.
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: [Microsoft] [ODBC Microsoft Access Driver]Syntax error or access violation.
WARNING: File deletion failed for _IMEX_.'2012 ICD-9 Proc Claim Counts'n.DATA. ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
ERROR: Error attempting to CREATE a DBMS table. ERROR: CLI execute error: [Microsoft] [ODBC Microsoft Access Driver]Syntax error or access violation.
WARNING: File deletion failed for _IMEX_.'2012 ICD-9 Proc Claim Counts'n.DATA. ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
The problem occurs when the table name in the Microsoft Access database contains the word PROC as a distinct or separate word in the table name. To circumvent the problem, change the table name so that the word PROC is not separate. You can use an underscore (_) or other characters similar to this.
proc export data= cnt_2012.all_2012_icd9_proc_cnt
outtable= "2012 ICD-9_Proc_Counts"
dbms=accesscs ;
database="c:\mydirectory\myaccessfiles.mdb";
run; 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® for x64 | 9.3_M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows 8 Pro x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows 8.1 Pro | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 R2 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2012 Datacenter | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2012 R2 Std | 9.3_M2 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2012 Std | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Enterprise 32 bit | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Enterprise x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Home Premium 32 bit | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Home Premium x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Professional 32 bit | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Professional x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Ultimate 32 bit | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows 7 Ultimate x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows Vista | 9.3_M2 | 9.3 TS1M2 | ||||
| Windows Vista for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| 64-bit Enabled AIX | 9.3_M2 | 9.3 TS1M2 | ||||
| 64-bit Enabled HP-UX | 9.3_M2 | 9.3 TS1M2 | ||||
| 64-bit Enabled Solaris | 9.3_M2 | 9.3 TS1M2 | ||||
| HP-UX IPF | 9.3_M2 | 9.3 TS1M2 | ||||
| Linux | 9.3_M2 | 9.3 TS1M2 | ||||
| Linux for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
| Solaris for x64 | 9.3_M2 | 9.3 TS1M2 | ||||
Access violations and ODBC errors occur when you export to Microsoft Access tables using the ACCESSCS driver. The problem occurs because the Microsoft Access table name contains the word PROC.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2014-03-04 17:52:40 |
| Date Created: | 2014-01-31 15:44:59 |