>Thanks Bob!
>
>>You can buy an replacement data engine for DBF files that supports files larger than 2 gig (supports 8.6 million terabyte tables), and is supposed to be as fast as VFP, (I haven't personally used it.) You can use it through ADO (ole-db driver) or you can use ODBC. You can also run the data engine on a remote machine if you want, to give you client server... anyway, it's called CodeBase, and I have heard good things about it.
>
>It operates like a native VFP database/table? I mean, I can directly use SEEK, USE, RLOCK(), etc.?

Well, if you use remote views, you can do those things on the view. I think there is a .DLL (COM) that you can access similar commands also. There is also an OLE-DB driver that comes with it so you can use ADO if you want.

As I said, I have looked at it, talked to support about it, but we decided to go to SQL Server for our product instead. But, Codebase is a good option if you want some of the features of SQL Server like the larger tables, and remote data engine but want to save your clients from buying SQL Server. But, it is better than MSDE since there is no 5 user limitation.

Codebase is royalty free... at least it was the last time I looked at it.

BOb