G
Guest
How do i block or restrict access to the tables and queries within my database that i am building? Do i need to go into the security piece?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Restricting access to only forms and reports and blocking from tables/queries
A
Albert D. Kallal
No, you do not need to setup security.
What you can do is use the options in tools->startup.
You do want to be careful with those options, as you might accidentally lock
your self out.
The procedure to setup things usually is:
Setup a form that launches when the application starts
(tools->startup->Display Form)
Hide the database window (tools->startup->Un-check Display Database
Window)
Turn off special keys (tools->startup-Un-check "Use Access special
Keys")
When you exit the mdb file, next time those startup options will be used.
However, what happens when YOU want to work on, and make changes? To by-pass
the startup options, you HOLD DOWN the shift-key during program startup. You
can eventually even dis-able this option as sometimes your users will know
about that feature also.
There is a number of additional options you need to set in the tools
start-up. So, just remember that all the options you need to set this up in
found in the startup options. You also should consider using a mde file, as
that also means that forms, and reports etc can not be changed.
Try downloading the 3rd example at the following link of mine. Try running
the application, and see how the ms-access interface is complete hidden.
Now, exit, and next time hold down the shift key to get in. Now take a look
at how the startup options were set. It is only a few mouse clicks, and all
of your application will be hidden. In that example, I also made a tiny menu
bar with two options
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
Try the above download. It takes less time to set this up, then it does for
me to type this answer to you!
What you can do is use the options in tools->startup.
You do want to be careful with those options, as you might accidentally lock
your self out.
The procedure to setup things usually is:
Setup a form that launches when the application starts
(tools->startup->Display Form)
Hide the database window (tools->startup->Un-check Display Database
Window)
Turn off special keys (tools->startup-Un-check "Use Access special
Keys")
When you exit the mdb file, next time those startup options will be used.
However, what happens when YOU want to work on, and make changes? To by-pass
the startup options, you HOLD DOWN the shift-key during program startup. You
can eventually even dis-able this option as sometimes your users will know
about that feature also.
There is a number of additional options you need to set in the tools
start-up. So, just remember that all the options you need to set this up in
found in the startup options. You also should consider using a mde file, as
that also means that forms, and reports etc can not be changed.
Try downloading the 3rd example at the following link of mine. Try running
the application, and see how the ms-access interface is complete hidden.
Now, exit, and next time hold down the shift key to get in. Now take a look
at how the startup options were set. It is only a few mouse clicks, and all
of your application will be hidden. In that example, I also made a tiny menu
bar with two options
http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm
Try the above download. It takes less time to set this up, then it does for
me to type this answer to you!
J
John Vinson
How do i block or restrict access to the tables and queries within my database that i am building? Do i need to go into the security piece?
Yep. Get the Security Whitepaper from Microsoft's website, or from the
Compuserve forum in my .sig, or right here:
http://go.compuserve.com/MSDevApps?SEC=2&FID=9376
Read it carefully... TWICE. Follow the instructions *carefully* - it's
quite possible to implement security so that it's irksome and provides
absolutely no protection from a knowledgable user, or so tightly that
nobody can get into the database ever again!
G
Guest
Thank you all....I will try the download for a long term solution and the startup options for a quick fix.........