MartyConnelly
martyconnelly at shaw.ca
Thu Mar 1 16:07:02 CST 2007
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