Quote Originally Posted by arnelgp View Post
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.
I do join the tables, but also having the rows PersonID and SkillID from the righthand site. Reason: I want a full list of all skills and their possible association to a person: Left Join ;-)

Quote Originally Posted by arnelgp View Post
next, you can just create a Linked ODBC table to ms access, then create the required query (joined table) into ms access.
Yes, i did that just to begin with, but sorted it out - for the moment at least. I want to hide away sql code and table structure as much as possible. Also, doing it that way is the more Client-Server approach, which brings me the benefit of not having to load all the data to the local machine for, lets say, joining them. This is fast and for a VPN-connection based system desirable.