"Adam Bataran" <u24032[ at ]uwe> wrote in message news:632382971f1bf[ at ]uwe...
[Quoted Text] > 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
|