Re: [MSAccessProfessionals] How to secure Front end which i give to my client along with .accde file

Hi Kahlid,

I always reply through email rather than the group website. This includes the previous messages by default. I think I posted something a while back about clicking a box or something that includes previous messages without having to copy and paste.

Can we assume you are developing an Access application for a customer? You should always have a front-end file with everything except the tables. The back-end file has only the tables. As per Daniel's site there are lots of tasks you can perform on your front-end to protect your designs based on your requirements. All of my customers work for the same employer as me so I don't employ all of his recommendations. You should only need to make an accde that gets sent to your customer. Each user should have their own copy of the front-end accde file. 

I'm not sure how you can do any development or testing of your application if you don't have a copy of their back-end file.

Regards,

Duane

---

From: Khalid Tanweer via groups.io 

 

Thanks Duane,

The best resource I have read on securing an Access front end is from Daniel Pineault https://www.devhut.net/2016/09/01/securing-your-ms-access-database-front-end/.

 

I don't understand how front end changes will affect "his latest inputs and changes in data". Updates to the front end should not make any difference with the data in the back end.

 

Duane

I would expect that you would have both front-end and back-end files for you to develop and test. I typically include some code at startup that changes the linked table connections to the customer's back-end file. 

 

You may want to occasionally get a new copy of the back-end file from your customer to be a little more realistic in terms of amount of data etc.

 

When you reply please include the previous messages in the email.

 

Regards,

Duane
...................................................
Duane,
Is this correct to paste previous messages from you or email is something else like on your email address. The things you mentioned in your last message could you please explain me more in this regard. Do you mean to say that i should keep my own back end and front end, particular not securing my own front  end, and giving my end user another secured front end, and further it makes no harm that he should have his own back end which i may get a copy of it occasionally.
Regards,
Khalid