Access 2010 error: ODBC connection failed

Question

Hello,

I have an user who pulls report from third party application (Juris) and is trying to open it via MS Access. He was able to open it until 2 weeks ago. Then when he tries to open the report he gets:

Run-time error "-2147467259 (80004005)": ODBC - connection to "Juris2" failed.

The file size is 474mb. Microsoft Access version is 2010 and machine OS is Windows 7. 

Initially, I chased Juris support for help but after extensive troubleshooting they couldn't help and decide to throw the blame to Microsoft Access. So, at this point they became useless and the only hope for remained to ask in this forum. 

Here is what Juris support recommended - Now, the Access report database size is well below the 2Gb limit, the tables have been linked, and the reports run but, not smoothly. The reports run if you open a linked table first but, that’s not the way they should function. My suggestion is for you to contact Microsoft support for assistance. 

I am not a database guy and really don't know how to troubleshoot this issue. Please advise or ask questions you have any. 

Thanks,

Answer 1

Stacy Clark_45,

I and Juris support went through this. It didn't help. We do it and close and re-open the file. Errors again.

Daniel Pineault:

1. I don't know what would been happened. But the issues dates for two weeks and the user is able to open other reports but not this one.
2. The reports file was over 2GB (2GB is actually the limit I heard). Juris managed to reduce it to the size above by removing all repeating tables. 
3. From the link you provided I am not sure how can I redo this persistent connection. Also how do I perform Compact and repair?

To everyone - Could the tables be corrupted in that case ?

Thanks,

Answer 2

Hello,

Do not worry about this error. Read the action of this blog to fix this error:

https://support.lexisnexis.com/system/selfservice.controller?CONFIGURATION=1058&PARTITION_ID=1&TIMEZONE_OFFSET=&CMD=VIEW_ARTICLE&ARTICLE_ID=43829&SOURCE_RELATED_ARTICLE=true&cust_prev_cmd=RELATED_ARTICLE&cust_PrevNextFlag=true&cust_articleId=40072&USERTYPE=1

I hope it will work for you.

Good Luck!

Answer 3

A couple things:

"He was able to open it until 2 weeks ago..."

Well, what changed at that point in time?  This is the root cause that would need to be addressed.

"The reports run if you open a linked table first but, that’s not the way they should function."

Sounds like you need to establish a persistent connection (which you should do anyways).

"The file size is 474mb"

sounds pretty big especially if there's no data.  I'd perform a Compact and Repair.

Always perform a backup prior to making any changes!