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

Don't forget the SQL Server 7 Patches for MSDE 1.0
http://www.microsoft.com/sql/downloads/sp4.asp?&SD=TECH&LN=EN-CA&gssnb=1
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q327068&sd=tech
MSDE 1.0 is not affected by Slammer worm
You cant have msde 1.0 and 2.0 on the same machine but does anyone know 
if you can run Access 2000 with MSDE 2.0?


marcel.vreuls at achmea.nl wrote:

>Robert,
>
>Thanks. I will install MSDE and keep you and the group posted about my
>findings.
>
>Gr. marcel
>
>
>
>
>"Robert L. Stewart" <rl_stewart at highstream.net>@databaseadvisors.com op
>22-10-2003 17:56:34
>
>Antwoord aub aan Access Developers discussion and problem solving
>      <accessd at databaseadvisors.com>
>
>Verzonden door:     accessd-bounces at databaseadvisors.com
>
>
>Aan:  accessd at databaseadvisors.com
>cc:   marcel.vreuls at achmea.nl
>
>Onderwerp:     [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
>>    
>>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>*****************************************************************
>Dit bericht is bij binnenkomst gecontroleerd op de
>aanwezigheid van virussen. Er zijn geen (bekende)
>virussen gevonden.  Active
>*****************************************************************
>
>
>
>
>
>
>********************* DISCLAIMER *********************
>De informatie in dit e-mail bericht is uitsluitend
>bestemd voor de geadresseerde. Verstrekking aan
>en gebruik door anderen is niet toegestaan.
>Door de electronische verzending van het bericht
>kunnen er geen rechten worden ontleend aan de
>informatie.
>************************************************************
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada