Can I make a linked table read only?
My situiation: I want to create a new db with a linked table from the original application giving the user of the new db the ability to create their own queries and/or reports but not be able to modify the table.
Everything I've tried lets me open the table and make changes to it.
Can anybody help please?
Thanks
My situiation: I want to create a new db with a linked table from the original application giving the user of the new db the ability to create their own queries and/or reports but not be able to modify the table.
Everything I've tried lets me open the table and make changes to it.
Can anybody help please?
Thanks