- Access is not a database. It uses the Jet database or can connect to SQL Server (and others). As a SQL Server front end, it is very fast. It's Jet that is slow. It wouldn't surprise me if Jet is dropped in a future version of Access in favor of SQL Server Express.
- SQL Server is definately Microsoft's database of choice going forward. SQL Server Express is free.
>Now that it is very clear the Microsoft are gradually putting VFP to bed, I wonder what new product will emerge and take it's place?
>Surely we are not going to be left with only 2 alternatives - Microsoft Access or SQL Server.
>There is definitely a market for a "middle of the road" product like VFP that is ideal for applications that:
>
> (a) Do not need something as powerful as SQL server
> (b) Are easy to deploy and have their own database engine
> (c) That are also more powerful and faster than MS Access
>
>In the past this market was taken up by products like VFP, Paradox, Powerbuilder, FileMaker etc.
>Since Microsoft does not believe that there is market for such a product anymore, are there any third party developers thinking on what will be a good replacement for VFP?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer