Making form stand alone

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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
 
Back
Top