make table query in outside database that is password protected

[csunsun]

if i need to do a make table query to a destination table in an outside database that is password protected, how do i tell the query what the password is so the table can be made? this is in microsoft access, by the way.

thanks!!!