Re: Alternatives to ADP?

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Sun, 21 Oct 2007 14:35:06 -0400, "Sylvain Lafontaine" <sylvain aei
ca (fill the blanks, no spam please)> wrote:

Points well taken. We're on the same page.
-Tom.


Where did I say that MS is still serious about ADP? There is only one place
where they are serious about support and (new) features and this place is
.NET.

One could argue that they are also serious about the future of JET with ODBC
linked tables as a frontend to SQL-Server; however, I find hard to see the
idea of taking ODBC linked tables as a front end to SQL-Server as anything
else as some kind of kludge. There are a good starting point if you don't
need any strong security but even when this is the case, their performance
will start to fail miserably when the complexity of the database will reach
a certain level of size and complexity.

When this fail start to appear, you can delay the ineluctable by using Views
and passthrough queries but passthrough queries are read-only and Views will
only give you a brief relief. The only long-term solution would then be to
use unbound forms but then, you will loose most of the simplicity and
advantages of using Access.
.