How can I implement security on a database so that the user can log into 

the front end mdb and the backend mdb will still be secured meaning that 

the same users could access it but not anyone else?



Thanks,



David

An easy little trick is to set up a database password on the back end using

the tools menu.



Then re-link the front end to the back end.



You will have to provide the password only once to establish the link

(Can't remember is you have to do it for each link or not). from that point

forward the front end will have permission by default.



The nice feature is that if someone should be nosing around and trips into

your back-end, they will not be able to access it w/out the password.



The only people that will be able to access that back-end's data w/out the

password will be the folks that have a copy of the front-end on their local

machines.



It's not fool proof, but it does keep the unsophisticated nosy-roses out!!

:)



Hope this helps,



Brian Pulliam

Berkley Risk Administrators Company, LLC

IS - Benefits

920 Second Avenue South, #700

Minneapolis, MN 55402-4023

PH#  xxx.xxx.xxxx









                                                                                                         

                    "David                                                                               

                    Bradley"             To:     "Access" <access@p...>                          

                    <davidbradley        cc:                                                             

                    @home.com>           Subject:     [access] Security on a database with attached      

                                         Access tables.                                                  

                    07/10/01                                                                             

                    07:42 PM                                                                             

                    Please                                                                               

                    respond to                                                                           

                    "Access"                                                                             

                                                                                                         

                                                                                                         









How can I implement security on a database so that the user can log into

the front end mdb and the backend mdb will still be secured meaning that

the same users could access it but not anyone else?



Thanks,



David