'Access 2007 & VB 2008' Thread RSS Feed

Access 2007 & VB 2008

Thu, 05 Nov 2009 12:52:31 -0700

I have a real problem here. I am connecting to an access 2007 database (accdb) via an OLEDB connection, and I have no idea why this code isn't working!

Imports System.Data.OleDb
Public Class Form1

    Private Sub Form1_Load(...)
        Dim dbCon As OleDbConnection
        Dim dbCmd As OleDbCommand
        Dim dbRead As OleDbDataReader

        dbCon = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0
;Data Source=C:\My.accdb;Persist Security Info=False;")
        dbCon.Open()  

        dbCmd = New OleDbCommand("SELECT * FROM CITY", dbCon)
        dbRead = dbCmd.ExecuteReader
        Do While dbRead.Read
            MsgBox(dbRead(1))
        Loop
    End Sub
End Class

The result is the program crashes with no errors. I tried it in a different form/project and it launches the forum without any messages. So, in short, I'm getting no error messages and I don't know why. It will not go past dbCon.Open(). Please help!

Re: Access 2007 & VB 2008

Wed, 11 Nov 2009 07:31:38 -0700

If the program is crashing, it has to be throwing an exception...

to get the error message try this:

    Private Sub Form1_Load(...)
        Dim dbCon As OleDbConnection
        Dim dbCmd As OleDbCommand
        Dim dbRead As OleDbDataReader
try
        dbCon = New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0
;Data Source=C:\My.accdb;Persist Security Info=False;")
        dbCon.Open()  
catch ex as exception
msgBox(ex.Message, vbOkOnly, "Error During dbCon.Open()")
return
End Try

        dbCmd = New OleDbCommand("SELECT * FROM CITY", dbCon)
        dbRead = dbCmd.ExecuteReader
        Do While dbRead.Read
            MsgBox(dbRead(1))
        Loop
    End Sub

My gut feeling is that this is a connection string issue
try this:

Dim DBName as String = "c:\path_of_db\dbname.dbext"
Dim ConString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBName & ";User ID=Admin;Password="

dbCon = New OleDbConnection(ConString)

Re: Access 2007 & VB 2008

Wed, 11 Nov 2009 08:49:08 -0700

Thanks! I tested everything out, and it still didn't work. I was looking around, and I realized that it's because first, I'm using the compiler in x64 so it can't find the provider, and second that I was using the code in the form load event, so it wouldn't throw errors.

Re: Access 2007 & VB 2008

Wed, 11 Nov 2009 13:30:46 -0700

Did you find a solution?

If not, you might find a more proper connection string (that has a provider that you can see on your x64 box) here: http://www.connectionstrings.com/

I go there a lot when I am writing con-strings for DB's I don't normally work with.

Good Luck!
Sean Campbell - firesickle.com

Re: Access 2007 & VB 2008

Wed, 11 Nov 2009 13:42:07 -0700

Yeah, thanks. I changed the compiler to target x86 machines, and moved the code to a button event. Thanks for the help!