How do I hide specified records from certain users in an Access database?
First, I’m nowhere near being a database wiz and need help. The database I manage is linked to SharePoint and requires a log in the SharePoint before accessing the database. Besides a the easily reversible filter, is there anyway to only let users see records they’ve created vs the seeing the entire list? Thanks.
You must add a user_name field to your database tables and build a query that select data using user_name as a criteria.
Besides using select * from table_products, you should use select * from table_produts where user_name = ‘xisto’ .
You can also use groups because they are easier to control/administer than users.