[AccessD] Convert mdb to accdb Problem

Rocky,

    Even in Access 2003, you need reference to DAO 3.6 in order to use a variable dimmed as property.

Best wishes,
A.D. Tejpal
------------

  ----- Original Message ----- 
  From: Rocky Smolin 
  To: 'Access Developers discussion and problem solving' 
  Sent: Saturday, April 18, 2009 05:50
  Subject: [AccessD] Convert mdb to accdb Problem


  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/>