foxpro tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any advantage/disadvantage to using foxpro for the BE and Access for
the FE of a multi-user (6 users on a LAN) application?

We currently have both the BE and FE in Access 2002, and we are nearing the
size limit in Access... so I was wondering about converting the BE to FoxPro.

Thanks!
 
Hi Jaden,

FoxPro files can go up to 2GB (the DBF, FPT and CDX parts of a table can
each be 2GB) so you've got a lot of room to expand that way. The FoxPro data
engine can handle a hundred users, so you've got a lot of growing room that
way too.

An alternative to MDBs and DBFs is to use MSDE for your data.
 
What about the speed of modifying/retrieving data from FoxPro vs Access (FE
is on workstation, BE is on network)? Is it comparable if the FE stays in
Access?

Thanks!
 
Hi Jaden,

With proper indexing VFP is extremely fast. Indexes should match the
expressions in SQL Where clauses, and also be on commonly used lookup fields
like CustomerID.
 
Back
Top