Hide Table from User of Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have created a Form to use as an application for data input, editing and
deletion. There is only one Table. I need to make it so that Joe-User can
open the Form and see ONLY the Form, no Table, no access to the database
itself. I don't even see the name of the Form in Windows Explorer, so not
even sure how to make that stand alone, but also need to make sure that
Joe-User cannot see or access the database or the Table I created. I want to
be able to provide a link to Joe-User to simply open the Form ONLY, so he/she
can do the data input that will automatically update the Table. Anyone know
how I can achieve this? Thanks.
 
On the on load event of the form run the code

docmd.RunCommand acCmdWindowHide
to hide the window with all the objects
 
Have created a Form to use as an application for data input, editing and
deletion. There is only one Table. I need to make it so that Joe-User can
open the Form and see ONLY the Form, no Table, no access to the database
itself. I don't even see the name of the Form in Windows Explorer, so not
even sure how to make that stand alone, but also need to make sure that
Joe-User cannot see or access the database or the Table I created. I want to
be able to provide a link to Joe-User to simply open the Form ONLY, so he/she
can do the data input that will automatically update the Table. Anyone know
how I can achieve this? Thanks.
Click to expand...

1) You can hide the table by right-clicking on the table name and
selecting properties. Place a check mark in the Attributes Hidden box.

2) You can display just the form by clicking on Tools + StartUp.
Select the name of the form in the Display Form/Page dropdown box.

3) You can hide the application window by unchecking the Display
database Window box.

3a) To show the database window (for yourself) either press F11 or
hold down the shift key when you open the database.

4) You can place a shortcut on the desktop to open the database (which
will display just your form).

5) Any user with a bit of knowledge can undo these steps.
 
Thanks, Ofer. I added that code and it does hide everything upon opening the
Form...however, upon opening the file initially, it still shows the Table and
everything else anyway, and there's no file name for just the Form. I need to
get it so that a user can open up the FORM only without seeing the db or the
Table - don't even want the user to know the name of the db. I'm sure I read
somewhere in MS's help files that a Form can be used as a stand-alone
application, but I'm not finding out how to do that.
 
Oh, thanks, Fred! I'm going to go over this info now and see if that will
work for me - much appreciated.

Yes, I realize that anyone with a modicum of knowledge can still get to the
db, and I tried to explain this to my boss. I didn't choose this method, it
was assigned to me.
 
I think the post you are talking about is in
Forms, look for the post "Open Access form only"

The answer was given by Dirk Goldgar:

look at this link:

http://www.mvps.org/access/api/api0019.htm

which shows you how to call the Windows API to hide the Access
application window altogether. Be aware that any form you want to show
must be both popup *and* modal, and there must be at least one such form
visible on the screen when you hide the Access window. Also be aware
that hiding the Access window this way severly limits what you can do in
your application.

--
 
Back
Top