[AccessD] Convert mdb to accdb Problem

A.D.:

Thanks for your reply.  At first I thought it odd that the reference would
disappear in the conversion to an accdb.  But when I try to select it in the
references in A2007, I get 'Name conflicts with existing module, project, or
object library'. Any idea why?  

Thanks and regards,

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of A.D.Tejpal
Sent: Friday, April 17, 2009 9:52 PM
To: Access Developers discussion and problem solving
Subject: Re: [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/>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com