>Doing research for a whitepaper that may or may not ever be finished (lol) I have been spending a lot of time with Access 2000 Projects that use MSDE as the data store.
>
>Then I spent a lot of time working with SQL Server 7.0 as the data store.
>
>Folks, I have to tell you that I was always in the camp that thought Access was a piece of sh*t but I'm now starting to think that Access 2000 married to SQL Server or MSDE is pretty powerful indeed. I am amazed at the changes in Access so that manipulating SQL Server data is exactly like manipulating that data in the SQL Server Enterprise Manager. Wow!
>
>Take a long, hard look at this combination of tools. It is so, so cool.
The biggest problems with Access have always been with Jet..and the fact that it stores everything in the MDB. With MSDE/SQL Server, there is no local data, so you'll not have Jet.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer