DCRAPACCESS
asked on
Excel connections to Access refresh fail
Hi Experts,
I have a Large Excel file with multiple connections (around 60) to the same Access Database.
If i refresh them all one of them is failing with a "Unspecifid error". If i then test the connection that fails i get this message:
"Test connection failed because of an error in initializing provider"
If i then close down the Excel file and open it again, i'm able to refresh that connection without any problems.
And if I then again try to refresh all, I get the same error but now with another connection. It seams that after refreshing x-number of connection, the files fails to refresh any more.
Please help!
I have a Large Excel file with multiple connections (around 60) to the same Access Database.
If i refresh them all one of them is failing with a "Unspecifid error". If i then test the connection that fails i get this message:
"Test connection failed because of an error in initializing provider"
If i then close down the Excel file and open it again, i'm able to refresh that connection without any problems.
And if I then again try to refresh all, I get the same error but now with another connection. It seams that after refreshing x-number of connection, the files fails to refresh any more.
Please help!
Last Comment
ASKER
The connections are created by using get data from Access, function in Excel. Then I change the connection to "Read" mode.
Refresh are done by looping all connections i vba, and then refresh them one at the time.
I'm refreshing them each night so the users dont have to wait for 5 min each time they open the document. So Backgroundqurey are disabled.
Refresh are done by looping all connections i vba, and then refresh them one at the time.
I'm refreshing them each night so the users dont have to wait for 5 min each time they open the document. So Backgroundqurey are disabled.
I think you would be better off with 'static' data in your workbook.
Remove the links and let the nightly sync code do all the heavy lifting.
You will get good results if you use an ADO recordset object and the CopyFromRecord method.
I describe other methods you can use in my Fast Data Push to Excel article:
http:A_2253.html
Remove the links and let the nightly sync code do all the heavy lifting.
You will get good results if you use an ADO recordset object and the CopyFromRecord method.
I describe other methods you can use in my Fast Data Push to Excel article:
http:A_2253.html
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Worked but not a great solution
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
How are you refreshing the links?
Why are you refreshing the links?