MS Access Connection String Error

Question

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt."

it appears after setting password on my Database. what should i do??

here is my code to path Database

 Private Sub Registration_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source= |DataDirectory|\Accounts.accdb;Jet OLEDB:Database Password=123;"
End Sub

i got this code in connectionstring.com but also same error appear.

thanks in advance.

senthilkumar2185 · Accepted Answer · 2013-12-12 03:20:25Z

1

Can you try this Code? And if it doesn't work, can you give the exact error message? If it doesn't recognize the database, You need to install access accdb driver. If it's corrupt, try to compact and repair database.

  con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" 
& Application.StartupPath() & "'\Accounts.accdb;Jet OLEDB:Database Password=123;"

edited Dec 12, 2013 at 3:20

senthilkumar2185

2,5983 gold badges23 silver badges38 bronze badges

answered Dec 12, 2013 at 3:12

chris_techno25

2,5176 gold badges22 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

chris_techno25 Over a year ago

Forgot to tell you that when using Application.StartupPath(), your database should be in the same directory as your .exe. Which, in your case, is inside the debug folder.

Aouie Over a year ago

thank you for reply sir but it didnt work. problem already in there. i already installed access accdb driver.

chris_techno25 Over a year ago

Can you give write down the exact error message? So you mean it does work without the password right?

chris_techno25 Over a year ago

By the way, I just noticed you're using MS Access 2013. You can check out this website, connectionstrings.com/access for more information. The default encryption scheme for 2013 doesn't work on the current connectionstring you're using. In Access, click on options and choose 2007 encryption method.

Aouie Over a year ago

i already used that code in the connectionstrings.com sir but same error appears.

|

Jade · Accepted Answer · 2013-12-12 03:13:17Z

0

Specify the full path of the database

Private Sub Registration_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    con.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source= c:\Data\Accounts.accdb;Jet OLEDB:Database Password=123;"
End Sub

answered Dec 12, 2013 at 3:13

Jade

2,9941 gold badge13 silver badges9 bronze badges

1 Comment

Jade Over a year ago

is your database is really exists in the datadirectory?

ankesh · Accepted Answer · 2014-04-09 19:12:21Z

0

you just need to do is go to datasource on left side. select the database that you want to connect right click on it and go to property in that first row will represent connection string. Try to use that string for the connection.

There is one example over here of msaccess database connection with vb.net in oledb. Just check it. It will be surely helpful to you.

http://vb.ankwebsoft.in/msaccess-vb-oledb-connection.php

answered Apr 9, 2014 at 19:12

ankesh

11 bronze badge

Collectives™ on Stack Overflow

MS Access Connection String Error

3 Answers 3

9 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

9 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related