The reason for asking this question now is that new developments are likely to be undertaken in Access. Thats because I'm the only VFP developer left in the company!

If you have the time, could you answer few questions I have:

How good is the development environment in Access 2000 (Access 97)? Is it still a limited macro/VBA language or has Microsoft boosted Access on that front as well.

Access always had its place as a easy to use querying tool, but it sounds to me as if it Access has grown up. Would you agree?

Do you still use VFP? Where would you use the VFP as opposed to Access?

I appreciate any advice in this area.

Jason

>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.