>Thanks for your answer, but how about the speed, time record accessing?
>
>Regards
>Teddy
If you are talking about any kind of data access, it depends on the back end. If you are using Access then VB is going to be the fastest as it can use Access directly. If you are using SQL Server then it's a toss up because both have to go through an outside source (OLE-DB or ODBC). If you want the fastest then you should use a VFP front end with a VFP back end.
VFP's data engine is very fast. It utilizes a technology called Rushmore to optimize its queries. Rushmore was integrated into the Jet and SQL Server data engines but VFP is still the king in this regard.
VFP can be used for any size application where I've heard Access starts to bog down at 10 to 15 simultaneous users and you have to scale up to SQL Server. VFP doesn't have this performance problem.
VFP does have one major limitation and that is database security. It has none. People can access the tables freely as long as they have a copy of VFP. Version 7 will have hooks to help alleviate this hole, but it still exists. If security is a major concern, then I would recommend SQL Server as the back end with VFP or VB as the front.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao