Michael R Mattys
mmattys at rochester.rr.com
Thu Mar 1 12:07:56 CST 2007
The problem is most likely disambiguation; use dbs As DAO.Database, rst As DAO.Recordset, etc Michael R. Mattys MapPoint & Access Dev www.mattysconsulting.com ----- Original Message ----- From: "Mark A Matte" <markamatte at hotmail.com> To: <accessd at databaseadvisors.com> Sent: Thursday, March 01, 2007 11:09 AM Subject: Re: [AccessD] How to import row number from Excel Sheet ??? > 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 ZuneT-make MSN® 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 >