Hello Out There,
I have a problem with opening a connection to the TimeTracker database in Access. I opened a fileDialog box and navigated to the Time Tracker Access database. The address of Time tracker is then inserted into the txtDataBase but, when I try to open the connection I get this error message:

The 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine

Why am I getting this error message and why can't I open the connection?
Thanx,
robodent

Hi again robodent,

Could you please Copy and Paste the piece of code with the error?

I used this to test and it works, all you need to change is the path, but the Dialog takes care of that:

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\Documents\Solutions\Time Tracker\ProjectTimeTracker.mdb"

Dim cn As New OleDbConnection(strConn)

cn.Open()

PS: if you hard code the connection string, does it work? also you DO have access or the Microsoft Data Access Components (Mdac) installed.

Good luck mate

________________________________
I'm just a noob...

Hi again also check out this link and download the tool to make sure your MDAC is configured correctly...

http://www.dotnet247.com/247referenc...yurl.com/388bm

I'm just a noob

Hello luishrd,

Thank you for responding to my question. It seems that I victimized myself again with another misspelling. It is amazing how many times I can look at a common word such as "Microsofoft" and not notice it was misspelled!!

robodent

Believe me I know!!! LOL


__________________________
I'm just a noob