Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is Access catching the Fox?
Message
From
29/03/2000 13:07:13
 
 
To
29/03/2000 09:54:56
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00352079
Message ID:
00352227
Views:
8
I don't think youll see any recent comparisons. There was one a few years back that came on the MSDN subscription but that's way out of date.

I have been working a lot lately with Access 2000 and MSDE (and SQL Server).

Generally speaking, Access has come a long way. Access Projects (capital is intentional) can seemlessly integrate with SQL Server and it's little clone, MSDE, to the point where you might even be confused if you're using the Access table designer or the SQL Server Enterprise Manager table designer. So, once you remove that stupid, clunky MDB database structure, as you can in Access 2000, you have a pretty robust tool to do applications in.

I daresay that you could give VB a run for it's money for client/server applications with Access 2000. It used to be prototype in Access, produce in VB but I can see where some apps could just stay in Access.

I think you'll find that the speed differences, using the MSDE data engine or SQL Server, are minimal, once you adopt the appropriate data access strategies.

>I have developed apps in FoxPro for a number of years and naturally come from a school of thought that says FoxPro is far faster than Access. I was just wondering how much faster?
>
>Over time Microsoft claims to be improving the speed of Access while FoxPro developers, like myself, will always say that FoxPro is the best.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform