Problem with ACCESS 2000 and VB

• jcoelho

  Grasshopper

  Points: 13

  More actions

  August 6, 2002 at 11:56 am

  #101217

  I've used VB successfully with SQL Server and ACCESS 97

  I am trying to replace the current ACCESS (access 97) database with a new ACCESS 2000 database.

  I keep getting the error'Unrecognised database format".

  The PC has Windows 2000 with Access 2000 loaded on it.

  Any help will be greatly appreciated!

  Thanks in advance

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 6, 2002 at 1:38 pm

  #434141

  Getting the error where? In VB code? Have you changed your connection string to use the Jet 4 driver?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter