Error refreshing two Data Connections to the same Access DB

[Roseus]

I have two data connections to different queries in the same Access DB. The second one always fails (regardless of which I run first).

When I look at the database, I notice that it has a lock file after I attempt the Refresh (not before), which I think is causing the problem. It stays locked until I close the Excel file. Can anyone help me to unlock the db as soon as my import is complete, so the second connection will run?

# # #
​

Additional Info

I'm using Excel and Access 2010.

The error:

"The text file specification 'MyQuery Link Specification' does not exist. You cannot import, export, or link using the specification.

Connection String (note: I'm using Command type: Table):

Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin
;Data Source=A:\folder\folder\My Database.accdb
;Mode=Share Deny None
;Extended Properties=""
;Jet OLEDB:System database=""
;Jet OLEDB:Registry Path=""
;Jet OLEDB:Engine Type=6
;Jet OLEDB:Database Locking Mode=0
;Jet OLEDB:Global Partial Bulk Ops=2
;Jet OLEDB:Global Bulk Transactions=1
;Jet OLEDB:New Database Password=""
;Jet OLEDB:Create System Database=False
;Jet OLEDB:Encrypt Database=False
;Jet OLEDB:Don't Copy Locale on Compact=False
;Jet OLEDB:Compact Without Replica Repair=False
;Jet OLEDB:SFP=False
;Jet OLEDB:Support Complex Data=False
;Jet OLEDB:Bypass UserInfo Validation=False

This question is a cross-post which I asked 5 days ago.

Lastly, based on this post, I've tried changing my Mode from "Share Deny None" to "Read", but it didn't help. Nor do I understand why it would have, but I tried.

 

[nuked]

Can you post all of your code. Are you closing the connection and disposing of it prior to making the second connection?

 

[Roseus]

Can you post all of your code. Are you closing the connection and disposing of it prior to making the second connection?

The code is very simple:

ActiveWorkbook.Connections("Connection1").Refresh
ActiveWorkbook.Connections("Connection2").Refresh

I'm not sure how to close the connection thereafter. Since it's just a simple Refresh, I would think it would close itself after it was complete, but that doesn't seem to be the case.

 

[Roseus]

Bump - does anyone have thoughts on this issue?

 

[Roseus]

Bump.