Yes, it is a commercial, but she does a good job of it.
May 28, 2010 at 11:17 AM
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.
Thank you. I look forward to the book.
Woody - (Information Solutions) Sacramento
Nov 25, 2009 at 10:53 AM
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.