Open recordset in remote database with user-level security

[swedbera]

I am trying to build a report based upon records in a remote database that
has user-level security implemented and cannot figure out how to do this.

Can someone please point me in the right direction?

Arlene