Forum Discussion
EMcEwen
9 years agoFrequent Visitor
Error when refreshing/adding any Access data sources
I've suddenly started getting the below error message when refreshing/adding any Access data sources. Any ideas? Error Message: The specified key is not a valid size for this algorithm. Paramet...
CahabaData
9 years agoMemorable Member
I could not link/get-data from an Access table that was an Office 32 bit installation where the PBI installation was a 64 bit installation.
I set up a work-around by exporting the Access table to Excel, and for some reason the 32 bit install involving Excel did not bother PBI.
I was never able to clarify why Excel is okay but Access not okay in this scenario.
Possibly your original set up was with Access/Office 64 bit and there was a change to a different PC with a different install?
Perhaps this helps.