Can only Refresh MSQuery as Read-Only

[earlymonk]

I have excel data files saved on a shared drive that users have read-only access to. When users go to refresh the connection they get this error:

"Unexpected error from external database driver()."

​

Followed by a prompt to select the workbook for the query. If users select "Read-Only" the refresh works. Otherwise they get the same error again.

Is there any way to set the query so that it's always read-only? Or is there a way to set that property via VBA? Users end up refreshing via a macro anyway...

Thanks much - this one's killing me!

 

[earlymonk]

Solved!

Super simple! Just added this little nugget to the connection string:

ReadOnly=1;