Prev: Novice - using macro to protect with password
Next: Help with looping in Excel
From: MJ on 25 Jan 2010 12:06
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
 | 
Pages: 1
Prev: Novice - using macro to protect with password
Next: Help with looping in Excel