Charlotte Foust
cfoust at infostatsystems.com
Thu Mar 1 13:18:56 CST 2007
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