Acceler8DB. The "standard" is to use the VB Class wizard that ships with the Asna product. My problem is that since I stopped being a Clipper programmer in 1994, I haven't accessed any database w/out using Sql. From what I see, the classes are generated for each table, with properties representing columns. You open the entire file and get access to one record at a time - via the class modules. This app will likely involve a lot of

dblTotal = 0
lngRecCount = 0
Open table...
Go to first row.
do until eof
dblTotal = dblTotal + AsnaObject.FILEFORMAT.POUNDS
lngRecCount = lngRecCount + 1
move to next row
loop
dblAverage = dblTotal/lngRecCount

That is a lot of trouble to do "select sum(pounds) as TotalPounds, avg(pounds) as AveragePounds from AS400.LIBRARY.Table" not to mention consumption of network bandwidth.

Oh well, its their money ;-)