Connecting to access database

by Jadranko Dragoje on Sep 11th, 2006

Code for connecting to Microsoft Access databse, opening and closing connection

Dim cn As New OleDbConnection
cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Data.mdb;Persist Security Info=True"
cn.Open()
cn.Close()

Comments on this Code Snippet

Permalink

Feb 24th, 2008

Re: Connecting to access database

hello sir. i tried that code but it doesn't work. it says that it's not defined. what should i do?

dengbadeng

Newbie Poster

Offline

1 posts
since Feb 2008

Permalink

Jul 18th, 2008

Re: Connecting to access database

did you add a header to it ? add 'imports system.data.oledb' as the header and try

kavithabhaskar

Junior Poster

Offline

123 posts
since Jun 2008

Permalink

Jun 4th, 2011

Re: Connecting to access database

which dbr u using-- access 2003 or 2007 ??
the code is for 2003
for 2007 use
"Provider=Microsoft.ACE.OLEDB.11.0;Data Source=|DataDirectory|Data.ACCdb;Persist Security Info=FALSE"

N A MSGBOX

pocohontus

Newbie Poster

Offline

9 posts
since Nov 2008

Permalink

Jun 5th, 2011

Re: Connecting to access database

'firs import

VB.NET Syntax (Toggle Plain Text)
imports system.data.oledb
Dim con As New OleDbConnection()
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=h:\MAINDB.mdb;"
con.open
statements
con.close
imports system.data.oledb
Dim con As New OleDbConnection()
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=h:\MAINDB.mdb;"
con.open
statements
con.close

Last edited by peter_budo; Aug 20th, 2011 at 4:13 am. Reason: Adding code tags

uv4u

Light Poster

Offline

47 posts
since Jan 2011

Previous Thread in VB.NET Forum Timeline: vb6 to vb.net

Next Thread in VB.NET Forum Timeline: How to fix resx error after changing file name

DaniWeb Message

Cancel Changes

User Name
Password