Rocky Smolin
rockysmolin at bchacc.com
Sat Apr 18 09:48:53 CDT 2009
Doug: I made the switch but got the same error on the prp. SO I'm going to try A.D.'s suggestion and start with a clean accdb, add the libraries one at a time and see where the conflict is. Will update shortly. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Saturday, April 18, 2009 7:27 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Convert mdb to accdb Problem 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 > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com