Access 2007 has turned me off ...
There seems to be a lot of that going around, particularly among developers.
MS owns Access and, IMO, MS has moved it along
the line from a RAD tool towards being an inter-
active tool. That's fine; it's their product.
Alas, since the advent of Dot Net, Microsoft appears to consider it the ONLY
developer tool. On the other hand, the number of 'Softies who considered
Access a "developer tool" has always been a distinct minority.
From my experience in a previous incarnation in the halls of a major
computer manufacturer, I can "relate" to that. In the 1980s and early 1990s,
I supported a software product that ran on mainframes, but was interactive
via the VM operating system and also, jumping through a few extra hoops, in
the MVS environment. It was much like a PC database application,
implemented on a mainframe. We had a number of customers who loved it
because it was so simple and easy to use to develop small - to - modest
sized applications. But, it was NOT classed as a development tool; it was a
"decision support system". Why? Well, of course, it was developed by a
maverick group in the Midlands Marketing Center in Warwick, England, and
_development tools_ were developed by the _System Development Division_.
Fortunately, the Mighty Marketing and Management Machine in that company had
bigger fish to fry, so didn't influence it to be constrained to not work
nicely for the kind of development for which it was intended.
But I don't see that it's an appropriate tool for
me anymore.
Certainly, it's not the tool of choice for creating web applications.
What does this have to do with Intolerable Latency
on a Wan? IMO, it's very unlikely that a well designed
dot.net/MS-Sql Server would suffer from such
problems.
How about a not-so-well-designed DotNet application? That's the kind of
Access-Jet/ACE application where we see the problems... I suspect Dot Net
developers who didn't know a lot more about their environment than the
Access developers we hear from (and quite often are able to assist to get
something decent running) wouldn't even get far enough to be asking these
questions in their appropriate newsgroups.
Good luck...
Larry