cant connect to ms access 2013 by password connection string
i working on project using c# and access 2013 , the wrong is : Cannot open database . It may not be a database that your application recognizes, or the file may be corrupt
i installed microsoft access2007 engine on my machine , if i testing the connection without password its works but with a password connection does not work . sorry for my english
my connection string like this :
<add name="con" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\visitor_db.accdb;Jet OLEDB:Database Password=2015;"/>
please help me to connect with password .
I faced with the same issue recently, but it was with Access 2010. I'm sure that you have tried to compact and repair your Access database, save this database in a new file or create a new empty database and import the data from the old database.
My operating system is a Windows 7 64-bit, in this case you can have installed an ACE provider in 32-bit or 64-bit on your machine. After some tests, I realized that 32-bit applications and 64-bit ACE provider have problems with encrypted Access 2007 databases (accdb) and the new encryption mode available in the Microsoft Access 2010 which is based on 128 bit key encryption. As you may know, the 64-bit ACE provider is compatible with 32-bit and 64-bit applications, but you will get that error if your application is compiled in 32-bit.
So there are the right environments for encrypted databases (accdb type):
- 32-bit Windows -> 32-bit ACE provider ->Your App has to be compiled for 32-bit environments.
- 64-bit Windows -> 64-bit ACE provider -> Your App has to be compiled for 64-bit environments.
Other configurations have failed on my tests for encrypted Access 2007 databases (accdb).
Hope this helps!!!
thank you for answer , i fixed the problem , by encrypt database with microsoft access 2007 , its work correctly with access 2013 .
Need connection string for Office 2019
I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database. For .xls files, I use the connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...;Extended Properties Excel 8.0;1 vote2 answersMark Cykowski1 month ago
Macro ne fonctionnent pas avec le runtime access
Bonjour et merci voici mon besoin j'ai un fichier excel qui me permet de gere mes contact depuis un userform dans le quel il y a des textbox et une combobox qui a pour base une table access0 votes0 answersM'chi1 month ago
Excel VBA ERROR ODBC connection failed
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.0 votes1 answerKashif Khan2 months ago
Interbase ODBC to Access with foreign characters
I have a legacy Delphi database, with an application written in Borland Pascal. It's an old system, running on a virtual XP box, since it won't run on anything newer.0 votes0 answersPete D3 months ago
User Supplied OLEDB Password
Is it possible to supply a database password that is let's say supplied when the user logs into the website. Example "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\MyName\Documents\mywebsite_assets\database\database.mdb; Jet OLEDB:Database Password=" + strPassword0 votes0 answersSteve Hammock8 months ago
Simplest way to get ADO.NET conection string for mdb database
I'm learning ADO.NET and have been stuck for DAYS trying to get a connection string for a plain, vanilla .mdb database. I've been trying potential connection strings and permutations from this site but NOTHING works; the database connection is never opened.0 votes1 answerAnonymous user9 months ago
Passthrough query connstring from Access VBA to Azure SQL works on one PC and not on others!
Hi, We have an Azure SQL database and a local Access app that needs to interact with it. Using VBA-generated pass-through query definitions to grab data as needed, no linked tables and no permanently saved queries.0 votes0 answersMike Noviskie11 months ago
What is the Connection string for ACCESS 2007 .mdb on Windows 7 (64-bit)?
I have tried the following variations of the same statement in Powershell 5.1: $objCon.Open("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\MyDocuments\WWW.mdb")0 votes1 answerRamon Tan11 months ago
Problem with connecting to an Access 97 db on Linux with Debian7
I have an Acces 97 database working on a Windows 7 PC where I can get data from it by XAMPP with phppdoodbc. I want to have this database on a QNAP NAS with Linux arm5, on Debian9 with a working Apache2 and PHP7, but I cannot get it to work. I now use:0 votes0 answersRoelon Jun 01, 2018
ASP connection to .xls
I am trying to insert excel data into an access database. The code below works perfectly for me even though it gives me access denied after successful upload. <% Set cn = CreateObject("ADODB.Connection")0 votes0 answersWisdom Dekuon Mar 20, 2018
- Load more posts