Charlotte Foust
cfoust at infostatsystems.com
Wed Sep 26 10:16:16 CDT 2007
You'd be better off doing it manually. You can set references but if your code depends on them, you have to put the reference handling code in a module that runs before anything else and that references the VBEIDE. I've done it for a different reason, but believe me, it's far easier to set it manually. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Wednesday, September 26, 2007 8:05 AM To: Access Developers discussion and problem solving Subject: [AccessD] DAO References in New DBs Sorry I forgot to change the Subject...Any ideas on how to get around this...other than manually doing it everytime? ORIGINAL QUESTION: Hello All, I just converted a db to XP that used Ted Avery's front end updater. The problem I am having is the temp db that is created does not have a DAO reference...actually any new db I create does not have a DAO reference. How can I set this in VBA? Thanks, Mark A. Matte ----------------------------------------> From: jwcolby at colbyconsulting.com> To: accessd at databaseadvisors.com> Date: Wed, 26 Sep 2007 10:53:17 -0400> Subject: Re: [AccessD] Mucking around>> Open any module> Click tools / references.> Find and check the dao reference.>> That database will now reference DAO. AFAIK there is no way to force all> new databases to reference DAO automatically.>>> John W. Colby> Colby Consulting> www.ColbyConsulting.com> -----Original Message-----> From: accessd-bounces at databaseadvisors.com> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte> Sent: Wednesday, September 26, 2007 10:44 AM> To: Access Developers discussion and problem solving> Subject: Re: [AccessD] Mucking around>>> Hello All,>> I just converted a db to XP that used Ted Avery's front end updater. The> problem I am having is the temp db that is created does not have a DAO> reference...actually any new db I create does not have a DAO reference. Ho> can I set this in VBA?>> Thanks,>> Mark A. Matte> _________________________________________________________________> Discover the new Windows Vista> http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE> --> 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 _________________________________________________________________ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&sour ce=wlmailtagline -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com