I made a DB that is used by 6 people. At the end of the year I get hem all back and use a combine query to add them together.
I want to secure my queries and reports so no one can view my code but they can print a report if they want. I have 4 built in reports that I would like to limit but do not want to stop anyone from making their own query.
Begining July I will put my combine DB out on the shared drive too so my boss can run the reports to add them all up. But I do not want anyone viewing or changing what I have written.
Since they all have their own DB'd on the same drive I do not want to get into passwords. What can I do?
Thanks
I want to secure my queries and reports so no one can view my code but they can print a report if they want. I have 4 built in reports that I would like to limit but do not want to stop anyone from making their own query.
Begining July I will put my combine DB out on the shared drive too so my boss can run the reports to add them all up. But I do not want anyone viewing or changing what I have written.
Since they all have their own DB'd on the same drive I do not want to get into passwords. What can I do?
Thanks