Doug Steele
dbdoug at gmail.com
Sat Apr 18 09:26:40 CDT 2009
I tried this in Access 2007, and found that it works with the following references, in order: VBA MS Access 12.0 Object Library OLE Automation MS DAO 3.6 Object Library. If I try to add the MS Office 12.0 Access database engine... reference, I get the same message as you, and the message goes away if I remove the DAO library. So they conflict. However, if I replace the DAO library with the Office 12.0 Access database engine library, the code starts working again. Doug On Fri, Apr 17, 2009 at 5:20 PM, Rocky Smolin <rockysmolin at bchacc.com>wrote: > Dear List: > > I converted an mdb to 2007 format - accdb. When I start the accdb I get an > error in code in the Open event of the opening form - 'type mismatch'. It's > on the line > > For each prp in db.Properties > > > > prp is Dimmed as Property > > db is Dimmed as CurrentDb > > References are set to VBA, Access 12.0 Object Library, OLE Automation, CDO > for Windows 2000 Library (legacy app, you understand) , Calendar Control > for > 2007, Visual Basic for Applications Extensibility, Word 12.0 Object > Library, > and 12.0 Access database engine Objec (oops, ran off the side of the > References Dialog box). > > Am I missing a reference? > > MTIA > > Rocky Smolin > > Beach Access Software > > 858-259-4334 > > www.e-z-mrp.com <http://www.e-z-mrp.com/> > > www.bchacc.com <http://www.bchacc.com/> > > > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > >