2 Replies - 887 Views - Last Post: 26 October 2012 - 11:24 AM Rate Topic: -----

#1 ladyhan21  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 26-October 12

connecting vb to ms access dataabase

Posted 26 October 2012 - 06:22 AM

am trying to connect ms access database to a payroll system in vb6 using the ADODC and Data grid but it keeps telling me unrecognised database format. I learnt it was because I saved it in the 2007 format instead of 2002-2003, so I changed the format but am still having the same problem..anyone to help???
Is This A Good Question/Topic? 0
  • +

Replies To: connecting vb to ms access dataabase

#2 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 5949
  • View blog
  • Posts: 23,207
  • Joined: 23-August 08

Re: connecting vb to ms access dataabase

Posted 26 October 2012 - 06:31 AM

Please do not ask questions in the Introduce Yourself forum.

Moved to VB6.
Was This Post Helpful? 0
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 571
  • View blog
  • Posts: 2,979
  • Joined: 19-May 09

Re: connecting vb to ms access dataabase

Posted 26 October 2012 - 11:24 AM

What you learned wasn't entirely correct. If I remember rightly, the default access connect string in the ADODC is Access 97. You could try saving in that format if you can. The other way to go is to find the right connect property to match your DB. Since people almost never use the ADODC, you're going to have to do some trial and error to see what works. However, the connect property is similar to the ADO connection object's connectionstring property. You might be able to work out the correct value by comparing them.

If you get tired of trying, consider dumping the adodc and using ado objects instead. Much more flexible, much more info on how to use them.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1