Connecting to an access database

[deci]

You're absolutely right you did Emre you are correct,

but in your first step:

1. Go to "Administrative Tools" in "Control Panel". Find "ODBC Data Sources (32 Bit)" and double click on it.

which only listed:

1. SQL server

2. SQL server native client 

however using:

c:\Windows\SysWOW64\odbcad32.exe 

I was able to select labview among other options although i dont recall from the top of my head.

[deci · Accepted solution]

well this is a very very odd issue.

if i make a accdb database on my pc and put it on the network drive it wont connect with the orginal error in my first post, 

however!

If i make a new database and then import my data then rename/replace my database with the new copy it works perfectly? both files should be identical and none have user permissions 

maybe there was some sort of corruption in the orginal database? or maybe labview corrupted it with wonky drivers?

[ingePreguntas]

Hi i was following this thread, i find the labview choise en dsn tab, but when i test the conection a just see the error that i attached or this:

"Test conection failed because of an error  an initializing provider.[Microsoft][ODBC Microsoft Access Driver] Could not find the file (unknow)"

Iam working in windows 10 run in 64bits, and labview 32bits with acces 2016.

[etuzuner]

Hi ingePreguntas,

Are you using x64 or x86 version of Microsoft Office?

[Theo_Koi]

Hi Deci, I thank you and everyone else who contributed to this thread.
It offered me the final clues I needed to resolve the serious issues I had in connecting 32bit LabVIEW to an .accdb Access database.

I've been a developer for over a decade and never before have I needed to spend two days of my time to resolve an issue! For hours I combed through NI and other LabVIEW forums, the Database Connectivity User Manual, Microsoft technical articles, and even Youtube looking for a solution. I can only describe it as 'depressing'.

To help other developers in the future and hopefully save a cumulative century of wasted man-hours, I thought it would be a good idea to spend some time and compile the solution into a single document, which I am attaching here. Hopefully this is acceptable.

I know that if something like this was available it would have massively helped me. Please feel free to review and re-upload if necessary as I am sure there is plenty of space for improvements.

I have limited experience on databases so I tried to start by summarising just the essence of the workflow for creating a DB connection (for people with limited experience like myself), followed by a step by step solution of the problem in hand, and including some additional know how not mentioned elsewhere.

I hope people find this helpful.