[AccessD] Is it over for desktop apps?

[Paul Wolstenholme]

Expanding on John's comment...

I learnt a lot about using Access with SQL Server from this site:
https://accessexperts.com/starthere-sqlserver-access/

..but it was David Emerson who taught me to take that further and do ADODB
forms to speed things up when using a remote server.
In my case the remote server was at the other end of a VPN link rather than
on the public cloud, so not so different.
Linked tables (ODBC) expose whole tables to Access and it can be tricky to
discourage Access from grabbing every record in the table and filtering
what it needs locally.  That can be a problem when using a remote server as
tables grow in size - forms become slower and slower to open (too many
minutes).
With ADODB forms you have Access calling a SQL Server stored procedure and
passing parameters.  In that way SQL Server does the filtering (right where
the data is) and passes back only the required data records.  That is where
the serious speed improvements are gained!  Complicated filtering becomes
achievable without a speed penalty.

Paul Wolstenholme


On Tue, 13 Sept 2022 at 10:47, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Hi JWC!
>
> Have you tested this with N users at once? where N > 10, say. Not to
> challenge your point, just asking for the threshold.
>
> On Mon, Sep 12, 2022 at 5:48 PM John Colby <jwcolby at gmail.com> wrote:
>
> > BTW, if you use a link to tables in SQL Server on the cloud (remote
> > server), Access very nicely converts to transactions where it opens a
> > connection, gets or puts data, then closes the connection.  All of a
> sudden
> > you can use a "BE" on the cloud without corruption.  And it is dog slow.
> > But it works, entirely reliably.
> >
> > On Sun, Sep 11, 2022 at 6:44 PM Rocky Smolin <rockysmolin2 at gmail.com>
> > wrote:
> >
> > > Don't see any 'war' here.  Just a good discussion brewing.
> > >
> > > All the apps I have written have the FE on the client and the BE on the
> > > server.
> > >
> > > Some of those clients are remote.
> > >
> > > r
> > >
> > > On Sun, Sep 11, 2022 at 12:07 PM Arthur Fuller <
> fuller.artful at gmail.com>
> > > wrote:
> > >
> > > > Rocky,
> > > >
> > > > I am really not trying to start a culture war here. Where does the FE
> > > > reside on those apps you mentioned? Locally (including local server)
> or
> > > in
> > > > the cloud?
> > > >
> > > > On Sun, Sep 11, 2022 at 2:58 PM Rocky Smolin <rockysmolin2 at gmail.com
> >
> > > > wrote:
> > > >
> > > > > I have written desktop apps that, without any 'remoting'
> architecture
> > > are
> > > > > used by remote users calling in to my clients' servers. So they are
> > 'in
> > > > the
> > > > > cloud' but my app is a desktop app.  So how would you score that
> one?
> > > > >
> > > > > r
> > > > >
>
...