da**********@bigpond.com.au (DD) wrote:
My problem is:
I dont want the guest to be able to open the tables qrys etc only to
view the forms
when i apply the permissions and open the database the Guest has
access to everything
I am applying to the user Guest the following permission Read Data i
leave all other fields blank
As a general rule of thumb, don't apply permissions at user-level but at
group level. As the number of users grows it would quickly become
unmanagable. :o)
In order to deny access to the tables and queries, as well as setting the
permissions as appropriate you need to hide the database window using
"Tools ... Startup ... Hide Database Window". Use the same dialog box to
open your form on startup.
Be aware though that there are ways of bypassing the Hide Database Window
feature (holding <Shift> on open and F7). This issue has been discussed on
here at great length and a quick Google search on "bypass key" should get
you enough to go on.
HTH - Keith.