Hi Charlie,
>Poor man's SQL Server. Actually, if the data is on the same machine as the COM Server, you may get faster data access than SQL Server.
Yes, but speed is drastically reduced, if this table are accessed by any other station, too. IOW, if they are not opened exclusively, because then any modification would force VFP to re-read the index, something SQL server has got to do. Therefore SQL server can indeed beat VFP in speed, especially if the server is designed for SQL server, having much RAM and fast disk access.
Christof
--
Christof