Access 97 – Restrict Records by login

I want to create a login procedure that restricts the user from seeing any records that they are not assigned to as a user on that record.

Table has a user id field. Based on the user id field I want to see only the records that are mine. If it’s a query I won’t be able to update the underlying records.

Also need to include a override user that could see all – i.e. management.

Example: A contact mgmt database where I only see the contacts that are mine and not the whole company.