Phil
This took some time for me to figure out. Thanks for the Challenge! When you build your connection to the ULS database you have to also tell it where the MDW file is.
1. Put in your user name and password on the Connection tab.
2. Click on the All tab in the Data Link Properties.
3. Find the Jet OLEDB:System database and edit the value. Put the full path to your MDW as the value.
That should let you link up.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, "pdk444444" <pdk444444@...> wrote:
>
> I am trying to run a query against by access database in an excel sheet but am running into security issues
>
> my db is a .mdb with user level security
>
> in excel I have selected the 'get external data from access' option which takes me into the 'data link properties' panel.
>
> When i try the 'test connection' option it returns an error saying it can't find the wif
>
> How and do i specify which wrkgrp file to use?
>
> I have used this option with an unprotected db and it works fine.
>
> any help would be very much appreciated.
>
> cheers
>
> Phil
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar