Problem Note 5996: Access Interface to ODBC when accessing MSAccess data may cause
data to be overwritten if using APPEND operations
Using SAS/ACCESS Interface to ODBC to append data to a MSACCESS table,
may result in data being overwritten.
The problem will occur if you have defined a libname with the ODBC
engine to an MSACCESS source. Then you attempt to use the libname
assignment to append one MSACCESS table to another table.
The first row of values from the second table will be overwritten.
For example:
(this assumes you have 2 msaccess tables named MSA and MSB)
libname test odbc dsn=msaccess;
proc datasets ddname=test;
append base=MSA data=MSB;
run;
In this example, the first row of values in the table MSB will be
overwritten.
You can circumvent this problem by adding the following to the libname
statement
Insertbuff=2
We have patches that can be downloaded from:
V8.2 SAS/ACCESS to DB2:
A Technical Support hot fix for this problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82d204
V8.2 SAS/ACCESS to ODBC :
A Technical Support hot fix for this problem is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#82od02
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows 95/98 | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows 2000 Professional | 8.1 TS1M0 | 8.2 TS2M0 |
| Microsoft Windows NT Workstation | 8.1 TS1M0 | 8.2 TS2M0 |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | 8.2 TS2M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Third Party ==> Information Exchange ==> ODBC (Open Database Connectivity)
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2002-04-23 16:20:19 |
| Date Created: | 2001-10-04 11:47:23 |
