[AccessD] Compression slows down MDB

<<Very impressive knowledge Jim.>>

  Not really; you just have to hang around long enough<g>

<<I was unaware of the fact that SQL built on-the-fly actually had a temp
query associated with it.>>

 I should have been clearer; it's only if a SQL statement is used in a
record source or row source.  SQL in VBA code doesn't get treated that way.
It's only for Access objects.

<<Is it easy to associate the tilde queries with the corresponding VBA
statements I wonder ?>>

 Yes, the naming is fairly consistent.  Here's an example:

~sq_cfrmARInvoiceBatch~sq_ccboBillToID
~sq_cfrmARInvoiceBatch~sq_ccboBillToName
~sq_cfrmARInvoiceBatch~sq_ccboCreatedBy
~sq_cfrmARInvoiceBatch~sq_ccboModifiedBy
~sq_cfrmARInvoiceRptDialog~sq_cSelectList
~sq_cfrmARPrintPostInvBatch~sq_clstSelectBatchID
~sq_cfrmCompanyInfo1~sq_ccboCountryID
~sq_cfrmCurrentUsers~sq_cfrmAnnouncementsSubForm
~sq_cfrmCustomer~sq_ccboCountryID
~sq_cfrmCustomer~sq_ccboCustomerType
~sq_cfrmCustomer~sq_ccboInvoiceTerms
~sq_cfrmDepartment~sq_cfrmDepartmentSubForm
~sq_cfrmLookupLocation~sq_cembfrmLookupLocationSF
~sq_cfrmRTY~sq_ccboYards
~sq_cfrmVisits~sq_cembfrmVisitsDetailSF
~sq_cfrmVisits~sq_cembfrmVisitsPaymentsSF
~sq_cfrmVisits~sq_cembfrmVisitsSummarySF
~sq_cfrmVisitsPatientInfo~sq_ccboEnthicityID
~sq_cfrmVisitsPatientInfo~sq_cembfrmPatientInquirysfProcedures
~sq_cfrmVisitsPatientInfo~sq_cembfrmPatientInquirysfVisits
~sq_drptVisitInfo~sq_dChild106
~sq_drptVisitInfo~sq_dembrptVisitInfoSRBillings
~sq_ffrmAnnouncementEdit
~sq_ffrmAnnouncementView
~sq_ffrmChangePassword
~sq_ffrmCurrentUsersSubForm
~sq_ffrmLocations
~sq_ffrmUser
~sq_ffrmVisitsPatientInfo

  I've never really looked at them before because Access manages all of it.

Jim.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Saturday, January 28, 2012 10:18 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Compression slows down MDB

Very impressive knowledge Jim.

I was unaware of the fact that SQL built on-the-fly actually had a temp
query associated with it.
Is it easy to associate the tilde queries with the corresponding VBA
statements I wonder ?
Or does one try to match on the source statements ?


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com