Username/Password with vba error: "Method or data member not found"

Originally Posted by halatehini

ok thank you, i will try this
and yes i know how to write basic queries

If you don't know what a SQL string is you can't be writing SQL queries.