Excel 2007 query - Access MDB question
 

Question:

In Excel 2007, when clicking on the:

1) ‘Data’ Ribbon/Tab… and choosing..

2) ‘From Access’

and selecting any Access mdb, the database will be opened in
‘exclusive’ mode and will be locked for all other users on the
network!

Why???

When recording these steps, I see that the default system query uses
“Mode=Share Deny Write”.

Any workaround?

In Excel versions, prior to 2007, the default query connected to the
mdb in ‘readonly’ mode, which was fine.

Thanks.

mj