[AccessD] DAO References in New DBs

I don't really have the 'manual' choice in using the updater...since it creates a new MDB...

----------------------------------------> Date: Wed, 26 Sep 2007 08:16:16 -0700> From: cfoust at infostatsystems.com> To: accessd at databaseadvisors.com> Subject: Re: [AccessD] DAO References in New DBs>> 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>> --> AccessD mailing list> AccessD at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com

_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx