Unreconized database format

[jason12776]

I am trying to work with an Access database and when I attempt to assign the database to recordsouce for the data object, I get the error, unreconized data format. I had this error before and I had to download a patch or something from the microsoft website. I forget what it is though. Can anybody help me out?

Cheers.

 

[lovell811]

what does your source statement look like? ----------------
Joe

 

[johnwm]

Usual cause seems to be wrong data provider

For Access 97 .mdb use
Connection.Provider = "Microsoft.Jet.OLEDB.3.51"

For Access2000 .mdb use
Connection.Provider = "Microsoft.Jet.OLEDB.4.0"

For SQL
Connection.Provider = "sqloledb"
etc. etc.
It's all on Microsoft website Let me know if this helps

Check out FAQ222-2244
'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[CCLINT]

Upgrade to VB Sp5 and use MDAC 2.5 or higher.

 

[CCLINT]

Upgrading to at least Sp4 will work, but you also need to change the Connect property in the properties window to Access 2000