How do I connect database with calculated columns to VB.NET?

Question

0.00/5 (No votes)

See more:

Hi
i installed Microsoft access database engine 2007 & 2010 & 2016 ...(all at same time)
when i connect to simple database , it's connect successfully..
but when i connect to database with Calculated columns , error show "unrecognized database format"
so how can i solve it
>>> I use access 2019
>>> and visual studio enterprise 2015
i will appreciate any help
thanks>

What I have tried:

Microsoft access database engine 2007 & 2010 & 2016
create multiple databases

Posted 3-Sep-20 0:52am

Anmar Sattar

Updated 3-Sep-20 8:33am

Add a Solution

Comments

CHill60 3-Sep-20 6:55am

Share the code you are using to connect

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2020-09-03T01:18:00

Solution 1

At a guess, it's because you are opening a 2016 Access DB file using the 2007 database engine: it's a later version of the file, and the earlier engine can't understand it.

Posted 3-Sep-20 1:18am

OriginalGriff

Comments

Anmar Sattar 3-Sep-20 11:47am

thanks sir
when i uninstall access engine 2007 ,error show "the microsoft.ace.oledb.12.0 provider is not registered on the local machine"
but 2010 and 2016 are still installed
thanks

OriginalGriff 3-Sep-20 12:01pm

That's because your connection stirn git directly referencing the 2007 version ... which is the reason you are getting this problem.

Anmar Sattar 3-Sep-20 13:45pm

when i press add new connection and choose my database >>advanced
connection string is "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=mydatabase.accdb"
so how can change the engine version
thanks

Maciej Los · Answer 2 · 2020-09-03T01:33:00

Solution 2

Please, follow the steps provided here: Connect to data in an Access database (Windows Forms) - Visual Studio 2015 | Microsoft Docs[^]

As you provided less than minimum information required to answer the question, we can't help you more.

Posted 3-Sep-20 1:33am

Maciej Los

Comments

Anmar Sattar 3-Sep-20 11:41am

thanks for reply.
i know how to add data source but it doesn't work with database which contain calculated columns (in tables)..
what information do you need to know ?
thanks

Maciej Los 3-Sep-20 12:05pm

Well... Looking at your error message, you can't connect to MS Access database, but you did NOT provide information:
1) how do you create connection in code (or mannually)...
2) what OS version: 32 or 64 bit?
3) what formula you used in calculated column?

Anmar Sattar 3-Sep-20 13:39pm

ok:
1) Manually by "add data source",,,,,(in code work successfully)
2)64 bit
3)IIf((([listprice]/12))<=[received],"true","false")

Maciej Los 3-Sep-20 13:59pm

"(in code work successfully)" - i doubt.
You mentioned in the comment to the OriginalGriff's answer:
"connection string is "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=mydatabase.accdb""
A proper connection string is:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;Persist Security Info=False;
Note: that your connection string does not contain path to the database.

Anmar Sattar 3-Sep-20 14:28pm

sorry sir
but my point is "Provider=Microsoft.ACE.OLEDB.12.0;Data"
when i choose file , the explore add full path automatically
my problem with engine and database so i ignored the full path here
thanks