MartyConnelly
martyconnelly at shaw.ca
Fri Mar 2 11:58:37 CST 2007
If unchecked then unused. It won't let you check both at same time too See Doug Steele's Article Access Reference Problems http://www.accessmvp.com/djsteele/AccessReferenceErrors.html Mark A Matte wrote: > Thanks Marty, > > I also found a site that stated this error would occur if 3.51 was not > an option in the references list...and it was not...so I copied the > dao350.dll to this machine...then used the the code you sent to > register it...I didn't have to check the 3.51 3.6 is checked. Does > this mean that even though 3.6 is checked...the 3.51 library is used? > > Thanks, > > Mark A. Matte > > >> From: MartyConnelly <martyconnelly at shaw.ca> >> Reply-To: Access Developers discussion and problem >> solving<accessd at databaseadvisors.com> >> To: Access Developers discussion and problem >> solving<accessd at databaseadvisors.com> >> Subject: Re: [AccessD] references and errors >> Date: Thu, 01 Mar 2007 14:07:02 -0800 >> >> DAO 3.6 is backward compatible with Access 97 >> but with a 10% speed drop handling Unicode to ANSI >> conversion. You can use in Access 97 >> >> DAO 3.51 cannot read Access 2000 + mdb's >> >> Mark A Matte wrote: >> >> > No...just 97 >> > >> > >> >> From: "Charlotte Foust" <cfoust at infostatsystems.com> >> >> Reply-To: Access Developers discussion and problem >> >> solving<accessd at databaseadvisors.com> >> >> To: "Access Developers discussion and problem >> >> solving"<accessd at databaseadvisors.com> >> >> Subject: Re: [AccessD] references and errors >> >> Date: Thu, 1 Mar 2007 11:18:56 -0800 >> >> >> >> CurrentDb is still valid in later versions of Access and DAO, so I >> >> suspect it's something else that is causing the problem. Does the >> new >> >> machine have a 2003 and 2007 version of Access installed? >> >> >> >> Charlotte Foust >> >> >> >> -----Original Message----- >> >> From: accessd-bounces at databaseadvisors.com >> >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A >> Matte >> >> Sent: Thursday, March 01, 2007 8:53 AM >> >> To: accessd at databaseadvisors.com >> >> Subject: [AccessD] references and errors >> >> >> >> Sorry...forgot to change subject... >> >> >> >> >Hello All, >> >> > >> >> >I have an A97 db that users run reports out of...number of different >> >> >machines...same db. New machine won't run of compile...errors on >> "Set >> >> >dbs=CurrentDB". Error says restricted word or function or uses >> >> >Automation not available in Visual Basic. The only difference I can >> >> >see is the new machine has a reference to DAO3.6 and the other >> machines >> >> >> >> >have a DAO3.51 and I can't set a reference to 3.5 on the new >> machine. >> >> > >> >> >Any ideas? >> >> > >> >> >Thanks, >> >> > >> >> >Mark A. Matte >> >> > >> >> >_________________________________________________________________ >> >> >Win a Zune(tm)-make MSN(r) your homepage for your chance to win! >> >> >http://homepage.msn.com/zune?icid=hmetagline >> >> > >> >> >> >> >> >> >-- >> >> >AccessD mailing list >> >> >AccessD at databaseadvisors.com >> >> >http://databaseadvisors.com/mailman/listinfo/accessd >> >> >Website: http://www.databaseadvisors.com >> >> >> >> _________________________________________________________________ >> >> With tax season right around the corner, make sure to follow these >> few >> >> simple tips. >> >> >> http://articles.moneycentral.msn.com/Taxes/PreparationTips/PreparationTi >> >> ps.aspx?icid=HMFebtagline >> >> >> >> -- >> >> AccessD mailing list >> >> AccessD at databaseadvisors.com >> >> http://databaseadvisors.com/mailman/listinfo/accessd >> >> Website: http://www.databaseadvisors.com >> > >> > >> > _________________________________________________________________ >> > Don't miss your chance to WIN 10 hours of private jet travel from >> > Microsoft® Office Live >> > http://clk.atdmt.com/MRT/go/mcrssaub0540002499mrt/direct/01/ >> > >> >------------------------------------------------------------------------ >> >> > >> >No virus found in this incoming message. >> >Checked by AVG Free Edition. >> >Version: 7.5.446 / Virus Database: 268.18.5/707 - Release Date: >> 01/03/2007 2:43 PM >> > >> > >> >> -- >> Marty Connelly >> Victoria, B.C. >> Canada >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > > _________________________________________________________________ > The average US Credit Score is 675. The cost to see yours: $0 by > Experian. > http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVERAGE > > >------------------------------------------------------------------------ > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.5.446 / Virus Database: 268.18.5/707 - Release Date: 01/03/2007 2:43 PM > > -- Marty Connelly Victoria, B.C. Canada