Instead of querying the database, I am thinking of saving the QueryTables (of the resultsets) as application variables. The application variables would be deleted and recreating whenever the data is updated, which is not very frequently. Most of the data get's migrated from other access databases by DTS packages and additional changes can only be made by a small group of editors.
The problem I envision is when I want for example to order the list of projects (by country, by status, by project title etc..). I could always write a routine that will go through the QueryTable and order them but am not sure if it is worth it. Also what are the size limits of application variables? Thanks! Zeina ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
