Connect to Access 2016 database through OLEDB
I'm trying to make a simple connection to a microsoft access 2016 database through a vb.net code, it's very simple:
Cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Data\VBtest\ConnectigToSecuredAccessDB\Production3.accdb; Jet OLEDB:Database Password=aros20;"
The database was encrypted using MS Access 2016, when I run the code I get the following error message:
"An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll
Additional information: Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt".
When I decrypt the same database and use it with the connection string: Cn.ConnectionString = "PROVIDER=Microsoft.ACE.OLEDB.12.0;Data Source = D:\Data\VBtest\ConnectigToSecuredAccessDB\Production.accdb"
it works fine which means the database is OK and the problem is in the encryption. What could the problem be? I'm confused. Encryption of the database is very important and I need it. Many thanks for your help.
I had the exact same problem: Database working without password protection, OleDbException as soon as I put on a password. Now I'm not exactly sure what I did, suddenly it worked. Installing the 2010 AccessDatabaseEngine might have been the key, but now I'm not able to verify. I hope you find out!
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 Noviskie3 weeks ago
live chat app
Looking for the chat plugin for website? Trust the best to boost your customer support efforts. LiveChatInc - The fastest way to help your customers. live chat app0 votes0 answersSohit Sharma1 month 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 Tan1 month 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 answersRoel2 months ago
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 votes1 answerWisdom Deku4 months ago
vibratory bowl feeder
we provide quality viratory bowl feeders and we have many other machine which will give you idea, we are vibratory bowl feeder manufacture in pune and provide best services.0 votes1 answervibratory bowl feeder9 months ago
Study Guides or Test Sample for the position of Admin asst?
Study Guides or Test Sample for the position of Admin asst? I’m testing for administrative Asst in the civil service sector.So I’ve to take a test to MS Word and Excel. and it’s practical to test my abilities.0 votes5 answersLiza John9 months ago
Connect to Oracle using SqlSriverConnect
Fingers crossed someone can help. I am looking for a connection string to use in MS Access 2010 to connect to Oracle using SqlSriverConnect so that I can specify SQLDRIVERNOPROMPT. My attempts to format a connection string to date have been unsuccessful. Please accept my thanks in advance.0 votes3 answersDes Davies9 months ago
Access 2010 to SQL server 2014 for updateable recordset
Trying to create an updatable form in Access 2010 connected to sql server 2014. I Don't want to use linked tables as many results will be provided by stored procedures. Using0 votes3 answersunknown9 months ago
ODBC attribute query
hi What does MLD=0 represent in the attribute of a Odbc Connectstring? Thanks N0 votes0 answersN M10 months ago
- Load more posts