Security Access 2000

  • Thread starter Thread starter Ugur Caglar
  • Start date Start date
U

Ugur Caglar

Hello,

I have 3 questions rearding security. I have designed a
database and split it into front/back end. I put the back
end in the network so that everyone can link to it. But
when i protect it with a password, the front end is unable
to link to it. how can i supply that password to the
system.

My second question is: How can i prevent my users from
seeing the queries macros etc. in the front end by not
allowing them to press shift botton on loading access. I
do not want them to press shift and bypass the
switchboard. Moreover i do not want them to use any
shortcut keys. How can i do that.

Thank you
 
end in the network so that everyone can link to it. But
when i protect it with a password, the front end is unable
to link to it. how can i supply that password to the
system.
Click to expand...

I am not sure you really can do that. What I often do is create a small form
in the back end that is set as the start up form. The message box looks just
like a system message, and it simply informs the user that they don't have
permissions to open the file. That reasonably well keeps them out.
My second question is: How can I prevent my users from
seeing the queries macros etc. in the front end by not
allowing them to press shift button on loading access.
Click to expand...

You can disable the shift by pass key. At my ms-access site you will find a
nice little utility that lets you browse to your database and set, or un-set
the shift key by-pass.

Check out:
http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html
I do not want them to press shift and bypass the
switchboard. Moreover I do not want them to use any
shortcut keys. How can I do that.
Click to expand...

The short cut keys can be disabled, and also the general ms-access interface
can be disabled. All of these settings are in the start-up-menu.

Try downloading the 3rd file in the following web page.
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

The above is a sample word merge app in ms-access. I have used the start up
options to hide the ms-access interface. Try running it, and see if you can
view the database window etc.
 
All you have to do is re-link the front-end tables. When
you re-link, you will be prompted for the database
password.
 
Back
Top