Re: Link AS400 database wirh Access Database

The ODBC connection runs at priority 20, which is the same as interactive. 
If you don't know what you're doing, you can kill performance. You'd be 
better off with writing a program to create a flat file with the data you 
want and then use Access to get at that data set.


Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx





"Chaudhary, Sachin (GE Equipment Services,  Consultant)" 
<sachin.chaudhary@xxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
01/20/2005 06:09 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Subject:        Link AS400 database wirh Access Database


Hi

I want to run query on one of the largest files on AS400. Since it eats up 
a lot of CPU , I thought of Linking the file to Access database using ODBC 
connection. 
I will run the query in Access, and leave it overnight so that AS400 CPU 
usage is not affected at all.
However when I chose link table in MS Access , and try to select ODBC 
Databases, it offers selection of files from only 2 libraries PSCOMMON and 
QGPL!. There is no browse button so that I can select a particular 
production library, neither can I select any particular member of the 
file?
Isn't this weird??
Is there any place where I can get some info about AS400-MS Access??

Rgds,
Sachin

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