Exposing Form Only to General Audience

[Guest]

Hello,
I've created an Access DB at my company complete with a form for users to
add records. Is there a way for me to expose only the form so that novice
users do not have to open the .mdb file and navigate to the form? I've been
searching for this answer, but can't seem to make any headway. I'm using MS
Access 2000. I'd love to put this form on the corporate network so that I can
link to it from our intranet. Any help would be greatly appreciated.
Thanks you.
Cheers
-Mattio22

 

[Guest]

I think this might be what you are looking for --
Create a new database located on your network where your novices have rights.
Link the necessary tables and copy any queries that the data entry form will
need. Copy the form to the new database. Add a comand button to quit Access
when they close the form. Create a macro named Autoexec and have it open the
data entry form.
When the database is opened the data entry form will be auotmatically
opened.

 

[Guest]

Hi Karl,
Thank you very much. This is indeed a good solution that I was completely
unaware of. I just completed it in 5 minutes. The command button to quit
access is a good touch so that the users are not left with the application
open once they are done entering data. I also set the macro's "Window Mode"
level to "Dialog." I think that will prevent them from messing around with
the tables and queries. Thanks again. I appreciate the quick response. The
forum is great.
Cheers,
-Mattio

 

[Ron2005]

level to "Dialog." I think that will prevent them from messing around with

the tables and queries. Thanks again. I appreciate the quick response. The

To stop this in general unless they already know how to enter as a
developer.....

Go to
Tools
Startup
Uncheck the "Display Database window box"

Ron