>I mentioned ODBC as a solution for the 10 user database but they voted ODBC too >slow. Why wouldn't MS make dbf support native to VB?
As I mentioned in an earlier post, dbf support is native to VB's jet engine. Look at the data control in VB to see this, under the connect property list. FoxPro 3.0 is listed, as are 2.0, 2.5, and 2.6.
However, you could still use ODBC. I have found ODBC to be pretty fast. 10 users should not be a problem. The consistency it brings in using one API and higher-level data access object models results in increased productivity. Look at all the middleware vendors that package products that use ODBC. These are used in mission-critical, time-critical transaction processing environments that involve lots of money, transactions and data.
I'm really surprised that any VB group would not suggest ODBC (or know that VB supports FoxPro dbf's natively). After all, VB, ODBC, ADO, SQL Server, etc. are all the products and technologies that MS says work very well together.
I wish you luck in enlightening this group. It seems you might be more useful in teaching them then vice versa. :-)
Ryan Hirschey