[AccessD] Re: Performance ADO - DAO or ??

Marcel,

Looks like you are doing everything right.

Since you are using 2000, I would explore using
the MSDE for the backend.  You would be fine on
the number of users it is designed for.  Then I
would convert everything to an ADP and use ADO.
I have found that on one of my large forms, 8
subforms with 2 sub-subforms, in MDE it loaded
in about 15 seconds, in ADP < 2 seconds.

Sorry that I cannot give you any more advise than
that.

Robert

At 08:45 AM 10/22/2003 -0500, you wrote:
>Date: Tue, 21 Oct 2003 10:50:25 +0200
>From: marcel.vreuls at achmea.nl
>Subject: Betreft: [AccessD] Re: Performance ADO - DAO or ??
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <OFBDBE24B3.31190D20-ONC1256DC6.00304900 at achmea.nl>
>Content-Type: text/plain; charset=iso-8859-1
>
>Robert,
>
>    The FE is always an MDE and is 11MB in size. De BE is always een MDB
>    which differs from 24 to 150 MB
>    Generaly there are five users who are updating and entering data and
>    about 2 users who only read data
>    The FE is always local on the computers. The BE is always in f:
>    \oop\oopdata.mdb
>     Alle forms are showing a limited no of records and are never bounded to
>    a table
>
>
>Thanks Marcel