August 19, 201015 yr Somehow, I found out I'm stuck on this: When you need to have access to a table in a secondary file, how do you control access automatically? I explain myself: If I need to see data from a table in an external file, how can I connect to it with a specific privilege set that will not allow me to change data but only view them? I don't want to use anything complicated such as External authentication. Just for desktop use.
August 19, 201015 yr Set up a privilege set in the second file with the appropriate access. Assign this privilege set to a account with the same username and password as the one in the first file.
August 19, 201015 yr Author Of course! I know I've done this before but somehow couldn't get around it. So, two privilege sets with the same name but different settings right? What if I set the password (of the secondary file) to null to give access to more than one accounts from the other end - will it work?
Create an account or sign in to comment