how can I open an MS Access 2007 database with a password in c# ?
I have tried this: Conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\BioDB.mdb ;Password=1966;");
but it doesn't work.
-
2What exact error message are you receiving? There are many possible reasons why you couldn't open that database.ChrisLively– ChrisLively2010-03-09 19:51:36 +00:00Commented Mar 9, 2010 at 19:51
-
As a side note, one of my personal favorites is the complete lack of a provider for x64. I really don't like access.ChrisLively– ChrisLively2010-03-09 20:05:03 +00:00Commented Mar 9, 2010 at 20:05
-
1You can use Access 2010 beta for x64, drivers available now for download.Fionnuala– Fionnuala2010-03-10 14:04:04 +00:00Commented Mar 10, 2010 at 14:04
-
Why would there be a 64-bit Jet/ACE when there's no released 64-bit Access? If 64-bit is required, why have you chosen a data store that doesn't have 64-bit support? Looks like pilot error to me, not some lack in the database engine or its support by MS.David-W-Fenton– David-W-Fenton2010-03-12 04:31:10 +00:00Commented Mar 12, 2010 at 4:31
Add a comment
|
4 Answers
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:Database Password=MyDbPassword;
From:
http://www.connectionstrings.com/access
And as noted below use @.
Try this:
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BioDB.mdb;Jet OLEDB:Database Password=1966;"
You'll need to escape that backslash, or precede the string with @.
5 Comments
David-W-Fenton
Er, what backslash needs to be escaped? And in what context?
D'Arcy Rittich
The only backslash in the original post; in the context of a C# string.
David-W-Fenton
OK. C# programmers would understand that, but I think it would be better to be more explicit in an answer in specifying exactly what you're addressing.
D'Arcy Rittich
The OP stated they are using C# and the question is tagged C#. I think it is a bit redundant to keep stating the language.
David-W-Fenton
I think you're assuming too much about your readers and about the context in which your answer may be read.
This is the connection string to use when you have an Access 2007 - 2013 database protected with a password using the "Set Database Password" function in Access.
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
Jet OLEDB:Database Password=MyDbPassword;
Some reports of problems with password longer than 14 characters. Also that some characters might cause trouble. If you are having problems, try change password to a short one with normal characters.
