Senin, 28 Oktober 2019

[MS_AccessPros] Re: Securing FE

 

Hi Khalid,
Changes to a back-end should be rare compared with the front-end. If you have deployed your application to a single location at your client's then it may be possible to get enough off line time from them to make changes to a back-end and return to them. I have used code in the past that would:
1) on opening of the front-end, check the version of the back-end (value in a back-end table)
2) if the back-end doesn't include specific tables/fields, then use DAO or transferDatabase to update the back-end
3) update the back-end version

I could add fields, tables, indexes etc with code in the front-end. This required exclusive use of the database temporarily but had very little impact on the users. They might need to allow only a few minutes for the upgrade.

For updating the front-end I provided the MDE (this was a long time ago) which the client was responsible for distributing. Often I would help with creating a VBS script file.

Regards,
Duane

__._,_.___

Posted by: duanehookom@hotmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

.

__,_._,___

Tidak ada komentar:

Posting Komentar