I need some help please.

I am trying to use Microsoft Query within Excel to create querys from a
database I have created in Access. This works fine for databases i have
created without any security logins but as soon as I try to connect to a
database which has secured logins, it keeps coming up with an error message
saying I do not have suffient rights to adminster the database - even though
I am putting in the correct login username/password ( i am the
administrator). Any ideas/suggestions would be greatly appreicated.