Excel Queries using Access data

Im trying to create a query from within Excel. When I select new database
query and select a database which has no securtiy login/password, no problem,
works fine. However, when I try to source the data from a database which I
have created using user logins/passwords it says that I do not have admin
privilages to use the database even though I am putting in the correct
login/username in the popup window? Please can anyone help?

I've had limited experience with this sort of thing but I've always had to
strip out the protection on the Access Database and create a copy before
successfully running the Query............

Vaya con Dios,
Chuck, CABGx3



"baconroll" wrote:

> Im trying to create a query from within Excel. When I select new database
> query and select a database which has no securtiy login/password, no problem,
> works fine. However, when I try to source the data from a database which I
> have created using user logins/passwords it says that I do not have admin
> privilages to use the database even though I am putting in the correct
> login/username in the popup window? Please can anyone help?
>