first question on your stored proc, you are joining two tables, and only getting fields from one table? so what is the purpose of the join if you only want to show
fields from one side of the join.

next, you can just create a Linked ODBC table to ms access, then create the required query (joined table) into ms access.