[AccessD] Speed Issues on network just with Access App

Bill Benson bensonforums at gmail.com
Tue Oct 18 14:09:29 CDT 2016


RE:   Step 1 was to find all the data and row sources
that began with the word "SELECT", and then change them to named Access
queries. T

With the exception of your Make Table queries, right?

On Tue, Oct 18, 2016 at 11:04 AM, Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Lambert,
>
> I suppose that it's not immediately relevant to your situation, but you
> should at least consider migrating the BE to any one of SQL Express, MySQL,
> MariaDB or PostGreSQL, all of which are free. The data-port is easy;
> besides the Microsoft migration tools, there are a couple of tools
> available free from Bullzip that do an excellent job of porting Access data
> to various "real" databases.
>
> The difference in performance, as compared with the standard FE/BE in any
> format (MDB, ACCDB) is astounding. And it only gets better as you
> progressively migrate queries to Views and SPs. Using Access 2000 and
> beyond, a system I wrote supported upwards of 75 users at once, all hitting
> one single SQL Express database, and it far surpassed the MDB FE/BE system
> I replaced.
>
> I took it a bit at a time. Step 1 was to find all the data and row sources
> that began with the word "SELECT", and then change them to named Access
> queries. That makes them portable to Views. Step 2 was to migrate the data
> to one of the databases mentioned previously. Step 3 was to change one test
> workstation to address the new database. Step 4 was to compare the
> performance. Step 5 was to slap my forehead and exclaim, "Why didn't I
> think of this sooner?"
>
> Since then, I have never even considered an MDB BE other than for little
> test programs I write, and most of those don't even need a BE; they're just
> little one-offs to test some theory or other that I'm pondering. Other than
> that, I have not much use for MDBs or ACCEDBs as the back end for anything
> serious.
>
> A.
>> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list