Hi All
I understand the functions behind access security in terms of users and which groups they belong to.
My only problem is this - Lets say when I log on as an Administrator then I would want to see all Tables, Queries. But lets say a user with only read only access logs on then I dont want them to see the Tables, Queries.
Can this be done? to say that when a user logs on with Admin rights so he can see all tables and queries but a user with read only NOT to see tables and quesries?
Thanks
I understand the functions behind access security in terms of users and which groups they belong to.
My only problem is this - Lets say when I log on as an Administrator then I would want to see all Tables, Queries. But lets say a user with only read only access logs on then I dont want them to see the Tables, Queries.
Can this be done? to say that when a user logs on with Admin rights so he can see all tables and queries but a user with read only NOT to see tables and quesries?
Thanks