I am quite surprised to see the kind of functionality you can get with Access on the Web. My first thought was that trying to write a web applicaiton by use of Macros was a bit rediculous. But I think I am going to have to adjust my thinking. There are
not many with the talent of Jeff Conrad. But if the rest of us mere mortals are able to do half of what the demo shows, I can see a real advangate for small to medium sized businesses.
Often what is most important is not what is said, but what is not said. I am hoping there are not big gotchas hidden behind the PR. If not, Access on the web has possibilities. I still think, for myself, and for some clients, I will do them and me a service
by connecting them to developers using upper-end tools like .NET, but for things that don't require that kind of horse power, this is encouraging.
I too feel that trying to make an Access application work on the web is not necessarily a good deal. My guess is you could fly a 747 to the moon once you get out of the atmosphere, but that doesn't make it the best vechicle for doing so.
I am happy with the Access 2007 Interface and don't expect or even desire a great deal more from 2010. What I do wish, however, is that Microsoft would promote the product more, I mean for more important things than receipies and soccer games. I have been
writing client/server apps for twenty years and know how dramatically they can help a small business. The problem is that everyone went to the web and forgot about the concept of client/server, a concept which is not, (should not be) dead. Many many small
business problems are solved with a good local area network solution. This is entirely beyond the ability of most Access "users". It takes a qualified professional developer to make it happen, and MS seems more concerned about users that create soccer applications
than developers who create business solutions.
As for enterprise applications, IMHO, .Net and SQL Server are the better tools. In fact, I don't even court Access front-end and SQL Server back-end business. If SQL server is really what you need, use .Net. Differnt tools for differnt solutions. But
lots and lots of small business problems can be solved with a well written Access applicaiton.
I agree with Brice in some areas and disagree in others.
It is important for the customer to use the right tool for the right problem. Having programmed in .Net for almost four years I realize that it is a better solution for corporate or enterprise applications, especially where a web app is concerned. But Access
is actually a better tool for small business; I mean busineses in the one to five million a year category.
I like the Ribbon Interface and promoting 2003 is to no avail. The industry is not going to go backwards. Reduce and Simplify is the clarion call of small businesses, and Access fits that montra to a "T". Using the larger tools for problems involving
less that a quarter million records is like rolling out an Air Bus when a 737 will do.
I just wish Microsoft would market it (Access 2010) for more small business solutions. Nobody uses it for receipies and socker games. Many small businesses need to be using it instead of spreadsheets. In the hands of a professional developer it can do
wonders for a small to medium size business.