[ladyhan21]

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

[JackOfAllTrades]

Please do not ask questions in the Introduce Yourself forum.

Moved to VB6.

[BobRodes]

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.