Can only Refresh MSQuery as Read-Only

earlymonk

New Member
Joined
Nov 17, 2009
Messages
3
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

New Member
Joined
Nov 17, 2009
Messages
3
Solved!

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

ReadOnly=1;
 

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top