RE: #DELETED in Access Linked Tables

[Ken.Slaugh@xxxxxxxxxx]

Thanks for the reply Buzz, but that cannot be the reason for the #DELETED
results as other PCs on the network are able to open the linked tables in
Access97 and access the same physical files.

Thanks again,

Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/



                    "Buzz Fenner"
                    <bfenner@jonesboroc        To:     <midrange-l@midrange.com>
                    wl.org>                    cc:
                    Sent by:                   Subject:     RE: #DELETED in 
Access Linked Tables
                    midrange-l-admin@mi
                    drange.com


                    08/08/2002 10:19 AM
                    Please respond to
                    midrange-l






Ken, you may need to do a re-org (RGZPFM) on the linked physical file
compressing out all deleted records.

Buzz Fenner
Programmer/Analyst
mailto:bfenner@jonesborocwl.org

-----Original Message-----
From: midrange-l-admin@midrange.com
[mailto:midrange-l-admin@midrange.com]On
Behalf Of Ken.Slaugh@cm-inc.com
Sent: Wednesday, August 07, 2002 5:56 PM
To: midrange-l@midrange.com
Subject: #DELETED in Access Linked Tables

After installing CA Express Access 97 reports #DELETED for each value of a
linked ODBC based table. Anyone experienced this issue?

I'm in the process of discovering the CA/400 Version and Service Pack
level... Any ideas or help?

Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.