[AccessD] Terrible performance like I have never seen before

Jim, BE conversion to SS is something I have been planning to start doing
with my clients.  Can you give a bit more detail on how you proceeded?  Did
you convert the BE totally to SS, then debug the FE until it was working,
then tune it?  Or did you have 2 BE and gradually convert table by table?
Or other??

Thanks,

Doug

On Wed, Jul 7, 2010 at 7:43 PM, Jim Lawrence <accessd at shaw.ca> wrote:

> I have heard your story before and have held a couple of clients back from
> upgrading until I can transfer their BE to MS SQL or SQL Express. The last
> app that I migrated from a MDB BE to SQL Express, took about a month, in
> dribs and drabs, to re-write, with SPs and using ADO-OLE connection. (Real
> men and women do not use ODBC so we will not use that four letter
> euphemism,
> in polite company, again.) ;-)
>
> The new app now runs about twice as fast as the old 2003 FE/BE even using
> the retarded Access2007 FE. This fall or early spring I will be moving the
> FE to .Net and that will be an end to it.
>
> Jim
>
>
>