Member Avatar for Samarth_1

Hello,
I am a bit new to vb.net. I was learning Database in vb.net . I have created a MS Access file. But when I Started my Visual Basic (vb.net 2008 Proffestional) and then I Clicked the Option Add New Data Type (In Data), nothing came. Can someone help me for connecting a MS Access Database to vb.net 2008?

  • 2 Contributors
  • 1 Reply
  • 142 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by ManojBalaji3001

Dani AI

Generated

— below are practical routes to get an Access file talking to VB.NET 2008 and a few troubleshooting checks. was right that the IDE UI (Server Explorer / Properties) is one way; if that path fails, the programmatic approach always works.

Start with the IDE

  • Make sure a project (Windows Forms or Console) is open and selected in Solution Explorer before using Data -> Add New Data Source or Server Explorer -> Add Connection. The wizard can appear empty if no project is loaded or if the Access OLE DB provider is missing.
  • In Server Explorer use Add Connection; if Access is not available in the list then the required provider (Jet for .mdb or ACE for .accdb) is not installed.

Programmatic connection (reliable)

  • For .accdb (Access 2007+):
    
Imports System.Data.OleDb

Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Path\MyDb.accdb;Persist Security Info=False;"
Using cn As New OleDbConnection(connStr)
cn.Open()
Dim da As New OleDbDataAdapter("SELECT * FROM MyTable", cn)
Dim dt As New DataTable()
da.Fill(dt)
' DataGridView1.DataSource = dt
End Using


- For .mdb:

Dim connStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Path\MyDb.mdb;User Id=admin;Password=;"



Troubleshooting checklist
- Create a test UDL file (rename a .txt to .udl, double-click) to confirm a working provider and connection string.  
- If ACE is missing, install the Microsoft Access Database Engine redistributable.  
- Watch 32/64-bit: Jet is 32-bit only; if the provider is 32-bit, compile your app for x86.  
- Ensure the .accdb/.mdb file path and file permissions are correct and Access is not holding an exclusive lock.  
- If the wizard remains blank after these steps, try repairing VS 2008 or create connections in code as above.
Member Avatar for ManojBalaji3001

Hi Samarth 1, Thanks for your brief explain

cx            Try to connect MS Access file in property window. it is easy to connect your MS Access file easily
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.