Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

vb.net 2010 can not open 2007 access db

ds1960ds1960 Member Posts: 2
I am working on a vb.net application and I am having difficulty opening
an Access Database. The access database has been encrypted/passworded.
It also seems that the Server Explorer in Studio 2010 is also unable to open the database. The error I am getting is:
Can not open database ''. It may Not be a database that your application recognizes, or the file may be corrupt.

I have been to connectionstrings.com. I think I added everything correctly, but the darn thing still won't open. If I remove the password, everything works. Pleas tell me what I am missing... I am somewhat new to .net.

System Details:
Windows 7 64bit
VB.net 2010
Access 2010 - 2007 format db, encrypted/passworded.
-----------------------------------------------
WinForm code:

Imports System.Data.OleDb

Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim ConnString As String
ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:UsersDanAccessDatabasesdb2007.accdb;Jet OLEDB:Database Password=" & TxtPasswordDB.Text & ";"
Dim conn As New System.Data.OleDb.OleDbConnection(ConnString)

conn.Open()
MessageBox.Show("Open")

End Sub
End Class
Sign In or Register to comment.