I need help on an issue similar to this. I have a replica of my database
that two people use to enter data. Now I need two other people to have
access to only two forms and reports. I have not been able to get there.
Can you please help me with this?

"Lynn Trapp" wrote:

Does your boss wish the client not to have a way to alter the application,
or does your boss not wish to add the cost of Access?

Jeff,
In my experience, clients typically are looking for some combination of
those 2 things. When I first started working where I do now, we took the
full version of Access off of all computers except for a few key people. We
were trying to prevent to seemingly constant proliferation of new Access
databases all over the company (it seems that nearly everyone in the
company who originally had Office Pro installed on their computers opened
Access and created a DB1.mdb) and to reduce the cost of purchasing full
licenses. Obviously, the financial types wanted to reduce the cost and the
IS department wanted to get rid of so many databases.

However, it looks to me like we have encountered a problem with the
proliferation problem since I managed that project. When new employees came
on board or when anyone got a new computer, it seems they were given the
full version of Access again. So, the proliferation problem started up
again.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm