Protection from Shift

Often appears need to close the access an user to window of the project Access. The Reasons can be a miscellaneouses:

1. Curious users become climb on base and have deleted макрос or have edited request (such possible after all and in the event of c .mde)
2. You have solved to sell its program. Than buyer less will see not necessary him element, so much the better (refer to p. 1)
3. The Hiding window project allows to do exhibit more suitable in work.

As a rule, one of the sign that developer шагнул from beginning to advanced most often is a hiding window exhibits.
The most Simplest variant of the decision of the problem can be a hiding window database through standard adjustment: Service Parameters of the start take away the mark window database . However, as was it already spoken in previous article, such protection so simply to take away, holding when start of exhibit Shift. In the same article was spoken about certain module , capable to block such possibility. We Get acquainted with one of them.

For building of the interface of protection создадим two макроса: AutoExec, AutoKeys. With the first You already introduce;make familiar with on article Avtolinkovka and reserve copying . The Second executes similar role intercepts striking the keys on keyboard. That he their intercepted, he must be identified AutoKeys (reserved name in Access). One more important moment - in menu Service Parameters of the start shall take away all marks, otherwise avoid protection from Shift will become very simply: Window - Display - a Window BD. But if disconnect all menu then in point menu "Window" will is removed only modes of the location of the windows, but window of the base is removed not will.

In макросе AutoExec we shall give the command on start the form FrmStart, in макросе AutoKeys forms VKLOTKSHIFT. Moreover the form VKLOTKSHIFT will be started when striking the combinations of the keys Ctrl + Q. For this in constructor зададим the name макроса - ^Q.

Why so difficult? This is because if we simply зададим start the form in Service Parameters of the start then when cut-in of protection from Shift will be opened started window Access. We shall close the base for all in general, including from itself! For any lock must be a key: him and emerges the form VKLOTKSHIFT - through she is fixed and leaves protection. But if her(its) do hidden (refer to below) and start through макрос (the combination of the keys) we else shall more tangle the curious юзеров. Cut-in occurs through characteristic of the base Itsel

          DBS.Properties("AllowBypassKey") = True (or False)

Depending on importances of the password, carried in field of the form VKLOTKSHIFT this characteristic is assigned True or False. Then base is closed (that change have took effect)

          DoCmd.Quit acPrompt

The Ithaca, shall conduct test:

We Start our exhibit, holding Shift is opened starting form, window of the project locked. ZHmem Ctrl + Q, enter 1234, жмем Entering . The Base is closed. Once again we snap on the base, holding Shift is opened starting form, window of the project openly! And so do until bore.

But now on cause hidden object . There is one more possibility заморочить user. This is because in Access there is three variants of the image object:

Normal mode (in window database are not displayed hidden and system objects) is defaulted

Mode of the image hidden object (in window of the base melon are not displayed system objects)

Mode of the image system object (all objects are displayed)

The System object this built-in object database, determined as system, for instance table "MSysIndexes", or system objects, determined by user. For determination of the system object necessary that his(its) name began with symbol USys. For instance, add to name of the form, tables, report USys and they then and there is disappeared , will become hidden, but address to him from application possible in the same way, as usually.

To see them, it is necessary to do following:

The Service Parameters Vkladka type. In group to Display choose required variant put (take away) mark Hidden objects , System objects and t. d.

The Many users such protection capable will shave off with sense: even having been able to open application through Shift, they with surprise will find that what that forms or tables there no though when functioning(working) she is seen. But on professional, certainly, such trick will not act of course, they are aware of characteristic object database. But if take into account that majority curious most often throw the attempts to rummage if beside them was not got with the first times, that such protection claims attention.
The Findings:

1. Protection is from Shift possible to use only provided that the base is transformed in .mde. Otherwise her(its) easy avoid, having done idle time import all object in new base. In .mde as is well known without decompiling (breaking in) impossible do the import of the general modules, the forms and reports the most valuable contents of the base.
2. If you develop applications on its functioning, that usually best way of protection speak on shower with user (and with the authorities). Protection from Shift will serve like реечному lock on garage at desire is easy opened, but do not be him(it), garage has ripoffed else quicker.
3. Usually protection from Shift use in complex with other methods: привязка to computer, entry on password, cryptooperation data and t. d.

The Example, as so much for works, You may below.

Author: Admin Size: 39 kB It Is Added: 31.01.2007