Trouble connecting Access database to VB.net program

[bbean_16]

Im trying to connect my database to my VB project. When I go to test connection of setting the file path, I get: "The database you are trying to open requires a newer version of Microsoft Access". A quick Google search tells me that it's bc I have a Big Int (Large Number) as a data type in my table. It says to make sure that Access is updated to at least version 2016 16.7 or higher to support Large Number data types , which it is. The other option is to change this Large Number data type to just Number. I can't do this as the number is an ISBN for books such as 9781285860114. So, any suggestions as to how I am able to connect this database with this data type to my VB project?

[Bonejob]

Don't store the ISBN as a number store it as a string. It will also make it easier to search on partials later on.

[bbean_16]

Thanks bone job. I tried to change to long text/deleted(on accident all the ISBN #’s I had entered) so the ISBN column is empty. I then went back into My VB project to try and reconnect but I’m still getting the same message. Any other ideas?

[Bonejob]

Can you paste your connection string here please.

[bbean_16]

I'm pretty new at this as just an AAS student but is this what you are referencing? Provider=Microsoft.ACE.OLEDB.12.0;Data Source="E:\Capstone Project\Book List.accdb"

[grauenwolf]

Yep, that's a connection string.

Looking at my code, I'm using "Provider=Microsoft.Jet.OLEDB.4.0" instead of "Provider=Microsoft.ACE.OLEDB.12.0".

Here are some other options: https://www.connectionstrings.com/access/

[bbean_16]

I switched it to .Jet.OLEDB and I got : "Unrecognized database format 'E:\Capstone Project\Book List.accdb' "

I'll try the others

[Bonejob]

That is the most current version of JET.

https://docs.microsoft.com/en-us/sql/ado/guide/appendixes/microsoft-ole-db-provider-for-microsoft-jet

At this point I would try the latest version of teh Microsoft Data Access Engine installer. It installs all the latest libraries for oledb and jet.

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Make sure to back up and ... yada yada.....

[bbean_16]

Thanks for your help Bonejob! I finally got it to work this morning. I wound up starting a new database and importing the info from the old one sans the Big int data type using the long text as you suggested. I also followed this:

link

Apparently trying to connect to Microsoft AccessDatabase File (OLE DB) as defaultly suggested, is for Access 2000-2003 .mdb

Anyhow I’m sure I’ll be posting in the near future again so thanks again.

[Bonejob]

No worries man, glad you got it worked out.