Securing Multi User

Pvarga

Registered User.
Local time
Today, 00:53
Joined
Apr 6, 2002
Messages
50
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
 
From the Tools menu, under Database Utilites select Make MDE..., and follow the screens.

Read up on MDE files in the Help file. But basically an MDE is a "Microsoft Database Executable (MDE), it will copy your MDB and compile it into an MDE where you can distribute it with out worry of the code, queries, forms, table structure, reports being tampered with.
When you create an MDE, the database objects are locked and cannot be changed or viewed and the file cannot be converted back to an MDB either. Only the data is updateable. If you do this I STRONGLY encourage you to also look at "Splitting the Database", also listed under Database Utilities. Read the Help file on this subject also and then search this forum for questions on both there have already been hundreds of questions on both subjects.

good luck,
 

Users who are viewing this thread

Back
Top Bottom