Unrecognized database format .accdb

database
studio

#1

I am trying to create a connection to an access database (stored locally on the machine that the robot is running on). The access database is of format .accdb which is the latest version of access.
When testing the connection string I get the Unrecognized database format error. Is this latest version of access not supported?


#2

Are you using the connection wizard…

I have just connected to an accdb file using the following connection string

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\richard.denton\Documents\UiPath.accdb"

Unable to Execute Query - Access Database 2016
#4

Thanks James, I ran into the same issue and the error was indeed coming from a corrupted Access DB. A recover in Access solved the issue!


#6

Or just don’t use Access (yuck!)

I used to develop Access Databases so I can say that :slight_smile:


#10

Did you ever get this to work tmsctt? Seem to be having similar issues setting up a successful connection to an MS Access Db. Tried all the suggestions listed here, among some others. The Access version is 2016.


#11