| View previous topic :: View next topic |
| Author |
Message |
chvnnchmvprasad Newbie
Joined: 10 Oct 2005 Posts: 1 Location: india
|
Posted: Oct 10th, 2005 10:53 AM Post subject: Could not access MS ACCESS 2003 from VB 6 |
|
|
when i am trying to access an MS Access 2003 mdb file using oledb connection object i am getting an error unrecognised file format
my program looks like this
cn As ADODB.Connection
With cn
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Data Source= myaccessfilename"
.Open
End With
MsgBox "connected"
Exit Sub |
|
| Back to top |
|
dougthomas Moderator
Joined: 27 Jul 2005 Posts: 271 Location: Essex, UK
|
Posted: Oct 11th, 2005 02:04 AM Post subject: |
|
|
Hi,
I think you may need to update the Data Access Components (MDAC)on your machine. You will find MDAC 2.8 here:
[link]
You may need to go through the Microsoft Validation process before you can download it.
Regards
Doug _________________ If you can see the light at the end of the tunnel, it probably means there's a Train coming. |
|
| Back to top |
|
|