foxpro tables

[Jaden]

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!

 

[Cindy Winegarden]

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.

 

[Jaden]

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!

 

[Cindy Winegarden]

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.