SNIP
>The same applies to the jet database. Is the JET database ISAM or not ISAM. I guess this depends on your definition of ISAM.
>
>1. If you decide this is ISAM, then you must conclude that the internal structure of the physical database is not a measure of being ISAM or not. SQL servers database could be ISAM also in this case.
>
>2. If you decide this is NON-ISAM: Fact is that the Jet database suffers from the same trips across the server. Well how that comes ? Just because the engine is seperated from the phisical database. Therefore extra trips are not an exclusive property of ISAM.

Walter,

Just for your own edification... on page 611 of the "Inside SQL Server 7.0" book is a statement: "However, because cursors are record oriented, developers who are familiar with ISAM systems (such as IMS, dBASE, VSAM, or the Microsoft Jet database engine used in Microsoft Access) are often tempted. . .".

Jim

>
>Walter,