Linking Access 2007 to VB 2008 express

enillrae - Jun 27, 2009 at 02:22 PM
 Dan S. - May 16, 2010 at 01:20 AM
I am trying to link my access 2007 database to my visual basic 2008 express edition. however I don't seem to be able to do it and the tutorials online are quite different from what I'm seeing on my screen.

3 responses

Not sure if this is what you're looking for, but this is the code I recently used in VB2008 to write a record to an Access 2007 .accdb file without binding elements to a form. It works well and will even save the record if the file is already open.

Public Sub UpdateRecord()

'Location of the database (This one is saved in the bin/debug folder)

Dim dbPath As String = "File name here"

'Connection string, you must use this provider for Access 2007

Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;" _
& "Data Source=" & dbPath & "; Persist Security Info = False;"

'The following Using statement forms a connection to the database; all variables within the Using block have local scope

Using connection As New OleDb.OleDbConnection(connStr)

Dim cmd As New OleDb.OleDbCommand
Dim trans As OleDb.OleDbTransaction '

connection.Open() 'Open connection to database

cmd.Connection = connection

trans = connection.BeginTransaction(IsolationLevel.ReadCommitted)

cmd.Transaction = trans

cmd.CommandText = "SQL Statement Here"

cmd.ExecuteNonQuery() 'Execute command
trans.Commit() 'Save record

'Exit Using block, automatically closing connection to database

End Using
End Sub
Below is the link about how to link Access 2007 using VB 2008 Express. The tutorial is for beginner level, showing how to make a connection using wizard.
thank you