>I'm planning to create a VB application and am trying to figure out how
>to best store the DB. The DB tables can have as much as 500,000 records
>in them and can be well over 100MB in size.
>Which DB format will work best with VB. I want the queries to run
>quick. Will storing the DB in Foxpro take advantage of FoxPro's
>Rushmore technology. What about an SQL Server?
The number of concurrent users is more of a factor than database
size when working with Access. If you're working with more than
about 2 dozen, you should probably consider SQL Server.
If you are thinking about a true client/server db, you're going
to have to take a hard look at cost factors as well. A SQL Server
implementation will require some high-performance server hardware
as well as fairly expensive server software, client access
licenses, etc. Also, its less likely to be something you can
install and walk away from unless the site already has a SQL
admin who can manage the server side. If these factors aren't an
issue, you might want to go to SQL Server from the beginning,
otherwise you could consider starting with VB/Access and
"upsizing" to SQL later.
Regarding FoxPro and Access, both now use Rushmore for query
optimization. (In fact, Rushmore is one of the reasons that MS
acquired FoxPro, as I understand it. The other was to get a "foot
in the door" for moving xBase developers to SQL Server.)
Never underestimate the power of a WAG.