[AccessD] Which is fasted as a list control's Row Sourceproperty?

Well, that's interesting. I couldn't really identify any of mine to a
specific control object though. 

So, do you think there's no appreciable difference between the two then --
as a performance issue? It seems to me, that pure SQL should always be
faster, regardless of how Access communicates it to Jet. 

Susan H. 

Same:
Behind the scenes Access creates a fixed query for the literal string.
You can see the hidden fixed query which is prefixed by a "~" using
following code in a form module:
    Dim dbs As DAO.Database, qdf As DAO.QueryDef
    Set dbs = CurrentDb
    For Each qdf In dbs.QueryDefs
        Debug.Print qdf.Name
    Next qdf

Asger

-----Oprindelig meddelelse-----
Fra: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] På vegne af Susan Harkins
Sendt: 1. april 2007 23:51
Til: 'Access Developers discussion and problem solving'
Emne: [AccessD] Which is fasted as a list control's Row Source property?

A literal SQL string or a fixed query? 

Susan H. 

--
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

-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.24/741 - Release Date: 3/31/2007
8:54 PM