** Security Issue While Linking Excel or Word to Access Database **

12 Jul 2006 2:17 PM

Adam Bataran

Hello --

I have recently implemented security on a networked Access database (system.
mdw is in the same network location). The security at a user level seems to
be working fine.

However, now that the security has been implemented, I am unable to link
Excel and Word documents to the database. We leverage many Excel pivot table
reports that are linked to Access via the GET EXTERNAL DATA function in Excel.

In Excel, why I attempt to refresh the Pivot Table for the report linked to
Access, the Access login screen comes up but does not accept the username and
password. It is much like attempting to open the database directly without
using the Shortcut that specifies where the MDW file is. All I can suspect
is that the login does not know to look for the MDW file??

Everything else with the security works great, just cannot link Excel and
Word files. Any thoughts?

Thanks so much,
Adam

12 Jul 2006 2:50 PM

Keith Wilby

Show quote Hide quote

"Adam Bataran" <u24032@uwe> wrote in message news:632382971f1bf@uwe...
> Hello --
>
> I have recently implemented security on a networked Access database
> (system.
> mdw is in the same network location). The security at a user level seems
> to
> be working fine.
>
> However, now that the security has been implemented, I am unable to link
> Excel and Word documents to the database. We leverage many Excel pivot
> table
> reports that are linked to Access via the GET EXTERNAL DATA function in
> Excel.
>
>
> In Excel, why I attempt to refresh the Pivot Table for the report linked
> to
> Access, the Access login screen comes up but does not accept the username
> and
> password. It is much like attempting to open the database directly
> without
> using the Shortcut that specifies where the MDW file is. All I can
> suspect
> is that the login does not know to look for the MDW file??
>
> Everything else with the security works great, just cannot link Excel and
> Word files. Any thoughts?
>
> Thanks so much,
> Adam

Hi Adam,

My solution would be to push the data from Access to Excel instead of trying
to get Excel to pull it from Access.

Regards,
Keith.
www.keithwilby.com