Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting

Post new topic   Reply to topic
Could not access MS ACCESS 2003 from VB 6
View previous topic :: View next topic  
Author Message
chvnnchmvprasad
Newbie


Joined: 10 Oct 2005
Posts: 1
Location: india

PostPosted: Oct 10th, 2005 10:53 AM    Post subject: Could not access MS ACCESS 2003 from VB 6 Reply with quote

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
View user's profile Send private message Send e-mail
dougthomas
Moderator


Joined: 27 Jul 2005
Posts: 271
Location: Essex, UK

PostPosted: Oct 11th, 2005 02:04 AM    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Visual Basic Forum for Visual Basic Programmers VB Forum Index » Database & Reporting All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Visual Basic Forum runs phpBB | Forum Template © iOptional
VB Resources | SSL | Visual Basic