HOw to split back end and front end

[chrisjames25]

Hi.

Thanks to all the support on this forum i am nearer the stage of rolling out my database at work. It is by no means perfect but it will do the job in the short term while i work on improvedments etc.

My question is:

Is there a good guide or accepted way as to how to split the back end and front end of the database and ensure the front end is locked down so an employee cannot edit any of the form etc.

Our set up at work is we have a local server which is where i plan to load back end and each of the netwroked 5 comps have access. Not sure if you need that info but just wanted to make clear not trying to do this over web at moment.

Cheers in advance.

 

[isladogs]

As a starting point, suggest you read this link
http://www.fmsinc.com/MicrosoftAccess/DatabaseSplitter/

 

[The_Doc_Man]

As long as the networked machines are on hard cable as opposed to wi-fi, you should have a fairly straight-forward job ahead of you.