Error Number: 3343

• • Reply

  19 years ago

  by grobillard

  Greg Robillard

  , United States

  Joined 19 years ago

  What do I have to do to connect to an Access 2000 database.  No trouble connecting to older Access database versions using db

  Report abuse
• • Reply

  19 years ago

  by Pranav Shah

  Pranav Shah

  , United States

  Joined 20 years ago

  Make sure that you have an updated Service Pack, I think 5 is the latest.

  Report abuse
• • Reply

  19 years ago

  by grobillard

  Greg Robillard

  , United States

  Joined 19 years ago

  Pranav,
  

  
  Nope, that wasn't it.  I installed sp5 and am receiveing the same error.  I can connect to older versions of Access and create my own databases via the visual data manager.  Is there some additional components that I need to add once I install the service pack.

  Report abuse
• • Reply

  19 years ago

  by grobillard

  Greg Robillard

  , United States

  Joined 19 years ago

  I used an ADO connection and went with code.  This worked fine with the sp5 installation.

  Report abuse
• • Reply

  19 years ago

  by CodeWarrior76

  CodeWarrior

  Calgary, CA, United States

  Joined 19 years ago

  Are you using DAO or ADO?
  

  
  if you're using DAO you need version 3.6
  if you're using ADO you need ... I think it's 2.1 or higher.  Look for MDAC 2.5 on microsoft's site.  there are newer version out there right now, but they are only needed if you are using SQL server 2000 or developing with .NET.

  Report abuse
• • Reply

  19 years ago

  by grobillard

  Greg Robillard

  , United States

  Joined 19 years ago

  Strange,  I attempted to use the visual data manager to connect to the database, and I generate the error.  If I use either DAO or ADO and code the modules and forms themselves, I have no trouble.  
  

  
  I guess it was just my fault for attempting to use automation.

  Report abuse