#DELETED in Access Linked Tables

["Steve Landess" <steve_landess@xxxxxxxxxxx>]

I am running on the latest service pack for the release of OS/400 & CAE that
we are using...(V4R4M0).

After more research on IBM's web site:

http://www-912.ibm.com/supporthome.nsf/a80bff372a96bdfa8625672700593d01/7683
2b5b5752eb508625673c008314ad?OpenDocument

Sorry, it won't let you send deep links, I found the following document
titled:

Microsoft Access #deleted Errors


Following the suggestions listed in this document, I found that when I
changed the setup for the ODBC driver (under the Translation tab) to
'Translate CCSID 65535', it now works OK with V4R4M0 CAE.

This is similar to the problem that you may or may not have encountered when
using Data Transfer from AS/400.  If you don't specify (Under File >
Properties) to Convert CCSID 65535, the data gets transferred as binary
values when you run the file transfer.


----- Original Message -----
From: <Ken.Slaugh@cm-inc.com>
To: <steve_landess@hotmail.com>
Sent: Thursday, August 29, 2002 10:13 AM
Subject: #DELETED in CA/400 ODBC


> Steve
>
>      I got your voice mail regarding the #DELETED situation. The answer is
> 'Yes' it appears to be fixed now. The solution simply entailed updating
the
> service pack for CA/400. Find it at...
>
> http://www-1.ibm.com/servers/eserver/iseries/access/casp.htm
>
>      I hope this corrects the problem for you as well,
>
>
> (Embedded image moved to file: pic05844.pcx)