Problems with VB6 data-object and Access2003

[Guest]

I have made programm with visual Basic 6 Professional Version
and i have use the data-object to contact to access 97 tables

I have convert the access97 to access 2003 and

Now i triy to use access 2003 tables with same program (vb6)
I get the error message "Unregognised database format error 3343"

isit bossible to use vb6 codes to use access2003

 

[Douglas J Steele]

You need to ensure that you're using appropriate drivers for the new file
format.

If you're using DAO, make sure you're using DAO 3.6.

If you're using ADO, make sure you're using Provider=Microsoft.Jet.OLEDB.4.0

If you're using bound controls, I believe you need at least SP5 of VB6.

 

[Duncan Bachen]

You need to ensure that you're using appropriate drivers for the new file
format.

If you're using DAO, make sure you're using DAO 3.6.

If you're using ADO, make sure you're using Provider=Microsoft.Jet.OLEDB.4.0

If you're using bound controls, I believe you need at least SP5 of VB6.

Yup, Douglas is spot on. There was a problem with the bound controls and
working with the different 97 and 2000 mdb version. Making sure your VB
is patched up to the latest service pack will help with that.

However, if you've already converted your backend database to the 2003
format, there will be a problem since VB6 doesn't understand the 2003
file format.

This article at Microsoft discusses the error:
http://support.microsoft.com/default.aspx?scid=kb;en-us;238401

In addition to needing the latest service pack, you'll need to make sure
your MDAC and Jet components are updated as well.