View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MJ MJ is offline
external usenet poster
 
Posts: 2
Default 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