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