Making form stand alone

[Steve]

I have created a data base that is used by others in my team. I am however
concerned that some of the users my want to play with the database and mess
things up. Is there a way to make the database a standalone application, so
all the users can see is the input form? this way they can only enter the
required data and not play around.

Cheers

Steve

 

[Larry Daugherty]

Look in Access Help for any new or ambiguous terms ...

Split your application

Compile the FrontEnd

Compact (and repair) the FrontEnd

Place the BackEnd in a network share to which all of your
application's users will have Read, Modify, Write & Delete privileges.

Depending on your version of Access use the Linked Table Manager or
"get external data - Link" to link the FrontEnd to the BackEnd tables.

Make MDE/ACCDE on the FrontEnd

Distribute a copy of the MDE/ACCDE FrontEnd to each user to run on
their own workstation.

The answer to the question you asked is "No". The above achieves your
intent.

HTH