I'm trying to query a table in a secured mdb database within another mdb database. I have created both so I am the administrator and have all the passwords and usernames. Both of these database have been secured using the recommended method by microsoft. I tried to open using the IN clause after FROM. This works as long as the admin password is set to "". I tried doing this in code but to no avail...Help!