Different logins in Application file vs Data file
I have seperated my application into a program file and a data file. I want to have different logins for each of my users so I can track who is making changes to the data and how often they are using the program and also to restrict some users to read-only. Right now I am creating the same logins in both the program file and the data file and it is working as expected. I don't need to have that many different logins to the data file. All I really need is full (for me), read-only and read-write.
Is there any way to have a different login for the linked tables then for the main program?