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?