Product Choice for Distributing MS Access Application

[Ann]

I would like to put a front end on an Access Database that does the following:
1. Launches the database.
2. Locks the user out of the back end of the program. In other words, the
user cannot see what is behind the forms...queries, form design, macros, etc.
3. Does not require the user to have MS Access on his computer.

What products will allow me to do that, and what tools are available to help
me learn how to do what I need to do?

Thanks a bunch for your help.

 

[Dave]

on older versions (at least up to XP) of access you can get the developers
kit that gives you the access run time engine that lets you do just what you
want. the runtime lets you distribute it with your database but the user
can only access the data and run existing forms and queries. i don't know
how this is done for the latest versions.

you can/could also create an '.mde' file out of a database that removes
source and prevents access to the table definitions for users who have
access that you don't want changing your database. check the help for more
info and caveats on doing that. these do not run by themselves though, the
user has to have access installed.