when the user logs in, their user id is stored in a session variable.
on the login page, open the server behaviors panel and double click the Security Assist Authenticate user server behavior. On the Session Variables tab, make note of the name of the User ID session that is being created.
you can use this session to filter the tables to return the information for the logged in user.
when creating a recordset set the filtering section to use the user ID column and a session variable, for the session variable name, enter the name of the session created at login