How to retrieve data from ms access 365 in VB.NET

Question

1.00/5 (1 vote)

See more:

Hi,

I have created a windows form application in which am displaying data in datagridview from ms access 365 in vb.net using oledb connection.

Please suggest me code in vb.net to get data from ms access 365.

Thanks & Regards,
Saurav Sinha

What I have tried:

Dim cn As OleDb.OleDbConnection
        Dim cmd As OleDb.OleDbCommand
        Dim ds As DataSet
        Dim da As OleDbDataAdapter
        Dim tables As DataTableCollection
        Dim source1 As New BindingSource

        cn = New OleDbConnection

        cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MsAccess.accdb;"

        Try

            ds = New DataSet
            tables = ds.Tables
            cn.Open()
            da = New OleDbDataAdapter("SELECT * FROM [EmpData]", cn)
            da.Fill(ds)
            cn.Close()
            Dim view As New DataView(tables(0))
            source1.DataSource = view
            DataGridView1.DataSource = view

        Catch ex As Exception
            MsgBox(ex.Message)
        End Try

Posted 4-Aug-20 3:22am

yash1507

Updated 4-Aug-20 4:02am

Garth J Lancaster

v2

Add a Solution

Comments

Maciej Los 4-Aug-20 9:42am

What's wrong with your code?

yash1507 4-Aug-20 9:58am

Getting error message
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

Richard MacCutchan 4-Aug-20 10:08am

You are clearly trying to use cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\MsAccess.accdb;". So, did you install it first?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-08-04T04:02:00

Start by checking your message box: what does it say?

If that isn't helpful, use the debugger to check the InnerException property whiuch may have more info.

If that isn't helpful wither, check you have the right redistributable engine components installed: Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Center[^]
There are different versions for 32- and 64- bit apps: you will need to install and distribute the appropriate version for your app configuration, if you want it to work.