Restricting user access to forms and main window

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

Hi all.

Is it possible to restrict user access so that they can only open forms (and
other objects) thru command buttons on forms that I do want them to see at a
particular time. I would like to block user access to all other objects in
the main window of Access and also prevent the user from even seeing the
main window if possible.

Thanks in advance for any suggestions on how to do this.

Anthony
 
All the settings you require can be found in the tools->start-up.

You should also consider using a mde, as then the users cannot modify the
forms etc. However, either can you, and you of course keep the original mde
when you do this.

Further, if you need to make updates, or this is a muti=user application,
then you need to split your database.

If you want a nice little simple example of the ms-access interface hidden,
and no code needed, but JUST the tools->start-up options, try downloading
and running the 3rd example at:

http://www.attcanada.net/~kallal.msn/msaccess/DownLoad.htm

Note, to get in after you "play" with the above application is simply hold
down the shift key during start of the application. If you user eventually
learn this trick, the you cal also disable the shift key.

And, for info on splitting, check out:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm
 
Thanks for your help Albert. That setting in the Tools>Start Up menu is just
what I was after.

I had a quick look at the database you kindly provided the link to and it
may be relevant to another problem I need to deal with. Thanks again.

Anthony
 
Hi Steve

Thanks for you response. I created a macro, which included the line of code
you suggested. This macro runs when the Report opens (ie OnOpen). However, I
kept getting an error message (ie "MS Access can't find the form "My Form"
referred to in a macro expression of VB code"). I tried fixing this by
adding a line of code elsewhere so that "My Form" remains open while the
macro runs. This time I received an error message telling me that, "This
action can't be carried out while processing a form or report event".

Any further suggestions???
 
please disregard above post

Anthony said:
Hi Steve

Thanks for you response. I created a macro, which included the line of code
you suggested. This macro runs when the Report opens (ie OnOpen). However, I
kept getting an error message (ie "MS Access can't find the form "My Form"
referred to in a macro expression of VB code"). I tried fixing this by
adding a line of code elsewhere so that "My Form" remains open while the
macro runs. This time I received an error message telling me that, "This
action can't be carried out while processing a form or report event".

Any further suggestions???
Click to expand...
 
Back
Top