Password and User Groups Issue

[FA]

Hi Freinds,
Can someone help me with the Password Issue.

I have the .mdb file on the shared drive and there are two group of
users one is called "Testers" the other one is called "Scheduler". I
need to make the user groups and their corresponding passwords so that
they can not see the form design and code, table design, macro. But
they will be able to run the forms, enter data, delete data, edit data
from forms.
I went through the Database Security in tool menue and tried to create
the user groups and their passwords but its so confusing and its not
working.

Is there any way can someone tell me the VBA Codes for making the above
functionality. Also where should i put those codes.

Thanks

Moe

 

[Guest]

Hi,
you don't really need to use the security wizard for that.
Check out the settings under tools--startup...uncheck show database window
at startup, uncheck shortcut keys and menus and...whatever you want.
Additionally turn of shortcut menus (right click) either globally there or
in individual forms under there property tab.
The only way to get back in the db now is to hold down shift while starting
up. This can be disabled as well if you want and you think your users could
figure that out.
HTH
Good luck

 

[Guest]

Additionally you could distribute your application as an MDE. This way NO
design changes will be allowed and it will be locked down.
Just a quick question do you have a true multi user environment set up,
meaning your application is split into frontend and backend?
HTH
Good luck

 

[FA]

Thanks Oliver, my database is on SQL Server and i have linked tables,
therefore i can not make the mde file because there are too many
objects and everytime i try to do that it fails. I have a true client
server environment meaning my .mdb file is on the shared drive and
database is on another server and every workstation is configured for
an ODBC connection to that database.

Let me know what should i do?

Moe