>Dear Mr. Obvious
>
>Long time listener, first time caller.
>
>My problems all started after prototyping a killer but relatively simple inventory app, when I was asked to finally connect to an IBM AS/400 Box and it's data contained there in.
>
>First of all Mr. Obvious I'm not an AS/400 kind of a guy. I just need you to placed me on the right path to pursue this unknown.
>
>It was horrible, when I finally created a local view from (2) remote views one to join the AS/400 data to my apps MS-SQL Server Data, things got ugly. It took forever (over 4 Mins) to open and BROWSE the table data (28,000 records).
>
>To let the DataEnvironment in a form do it seems even worse. What can I do or where can I go for answers?
>
>I'm using the IBM Client Access ODBC driver, I'm told. I've read some VFP help files but still feel void of information.
>PLease Help Me !!!

Well, first off...

Designing a client/server app with a browse of 28K records is asking for trouble. You should try to redesign the interface to cut down the data into smaller chunks.

That said now what version of client access are you using? If you are not using the latest release then data transfer rates are going to be SLOW! Look at the ODBC release version and see if the first digit starts with a 4. If not then you don't have the new driver. If the old client access is what is being used with no plans to upgrade then very little can be done with transfer rates. With the new driver you can pull data off the AS400 just a quick (if not quicker) as the SQL server.