how to open access encrypted in vb.net

Question

4.00/5 (1 vote)

See more:

i have table on ms.access encrypted with password. when i try to open it using vb.net, it can be accessed. i have tried code from connectionstring.com. i'm using ms.access 2013 and visual studio 2012
is there any suggestion, please?
this my basic code for connection when the ms.access is not encrypted.

VB

Dim kns As New OleDbConnection("provider=microsoft.ace.oledb.15.0;data source =" & Application.StartupPath & "\database.accdb")
    Dim da As New OleDbDataAdapter
    Dim ds As New DataSet
    Dim sql As String

Posted 25-Jan-15 0:45am

vendir

Add a Solution

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)

Wendelius · Answer 1 · 2015-01-25T00:49:00

Solution 1

You need to define the database password if the database is encrypted. For example:

VB

Dim kns As New OleDbConnection("provider=microsoft.ace.oledb.15.0;data source =" & Application.StartupPath & "\database.accdb;Database Password=PasswordGoesHere")

Posted 25-Jan-15 0:49am

Wendelius

Comments

vendir 25-Jan-15 6:57am

i have tried that and it shown error on my sql command. it said "Could not find installable ISAM." when i run it with no password access, it can work. or did i have to edit my code too?

Sub CARIUSER()
DS.Clear()
SQL = "SELECT * FROM userlist WHERE Username ='" & USERNAME.Text & "'"
DA.SelectCommand = New OleDbCommand(SQL, KNS)
DA.Fill(DS, "userlist")
End Sub

it shown error on da.fill

Wendelius 25-Jan-15 7:15am

As far as I know that error message is related to dbase, foxpro and other ISAM based files, not Access.

Have you tried using a different provider:
microsoft.ace.oledb.12.0

Also if you have 64 bit environment make sure that you have the 64 bit drivers installed correctly.

vendir 25-Jan-15 8:33am

if i using microsoft.ace.oledb.12.0 that mean i have to change my access file to mdb?

Wendelius 25-Jan-15 10:35am

No, as far as I know you can use version 12 with accdb files

vendir 25-Jan-15 23:08pm

it gave the same error
Could not find installable ISAM.

Wendelius 25-Jan-15 23:36pm

Are you sure that the driver is correct version. I mean if the program is 32 bit then the driver you have installed is 32 bit too.

vendir 26-Jan-15 0:14am

Yes it's the correct version
It shown no error if the database not encrypted and can run well

Wendelius 26-Jan-15 0:22am

One thing you could check is that does the program have both read and write access to the folder where the accdb file is and make sure that the file isn't read only.

vendir 26-Jan-15 4:50am

if the access not encrypted, the program can work well. that's mean for writing, reading the database. but if the access is encrypted, it get error just by running it.
did i have to install other thing other than access and visual studio?