[AccessD] Performance ADO - DAO or ??

Is it possible to use MSDE?

Rocky

----- Original Message ----- 
From: <marcel.vreuls at achmea.nl>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Monday, October 20, 2003 4:37 AM
Subject: [AccessD] Performance ADO - DAO or ??


> Dear group,
>
> It has been a while since I looked into this group. My daughter (7 months)
> took up most of my time recently. But work goes on so I would like to ask
> you the following.
>
> I am strugling with the following. I have about 6 access 2000 applications
> distributed among several customers. All database use DAO and have a FE
and
> BE. It works fine but know customers start complaining about performance.
> Expecially on a network envirnement.
> I have
>  - Looked through all the queries and changed all the SELECT *  queries
> with only the data wich is used
> - closed all recordset and database connection at the end of eacht
function
> of module.
> -  Removed databound forms as much as possible. This is a lot of work and
I
> do not know if i want to do this.
>
> But this all did not improved much.
>
> I am thinking about the following
> - Is it a option to move to ADO instead of DAO. Does this improve
> performance?. In my tests it does not matter much but perhaps I am missing
> something
> - The performance analyser in Access tells me to use fewer controls on a
> form. If I do this does this improve performance
> - moving to sql server. But this will cost my customer a lot of money and
> the won´t be happy.
>
>
> Any suggestions, ideas??
> I am thinking to rewrite the programms to VB, anyone experience, tips,
> tricks in this.
>
> Thansk marcel
>
>
>
>
>
> "dave sharpe" <davesharpe2 at cox.net>@databaseadvisors.com op 19-10-2003
> 06:32:54
>
> Antwoord aub aan Access Developers discussion and problem solving
>       <accessd at databaseadvisors.com>
>
> Verzonden door:     accessd-bounces at databaseadvisors.com
>
>
> Aan:  "Access Developers discussion and problem solving"
>       <accessd at databaseadvisors.com>
> cc:
>
> Onderwerp:     Re: [AccessD] ado recordcount
>
>
>
> John - This article may be of benefit
> Dave
>
> PRB: ADO: Recordcount May Return -1
>
>
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q194/9/73.asp&NoWebContent=1
>
>
> ----- Original Message -----
> From: "John Colby" <jcolby at colbyconsulting.com>
> To: "AccessD" <AccessD at databaseadvisors.com>
> Sent: Saturday, October 18, 2003 11:38 PM
> Subject: [AccessD] ado recordcount
>
>
> I am opening a recordset (raw table) that contains records.
> Move last, move first.
> EOF and BOF are both false.
>
> Recordcount = -1
>
> What gives?  How do I tell how many records in the recordset?
>
> John W. Colby
> www.colbyconsulting.com
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> _______________________________________________
> 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