

It will however, make the application useless to them since they cannot use any of the forms. The Control Systems Security Program (CSSP) also provides a section for control systems security recommended practices on the CSSP Web page. This will not prevent anyone from copying the database, nor will it prevent them from accessing the data. When remote access is required, use secure methods, such as Virtual Private Networks (VPNs), recognizing that VPN is only as secure as the connected devices. mdb in a safe place because there is no going back to it from the. This will prevent your security from being circumvented by bypassing the shift key lock.ĥ. They should refuse to open if the hidden form isn't open. Have each other form look for the hidden startup form with "IsLoaded" in their Open events. Have the startup form hide itself so that it stays open but invisible.Ĥ. In the startup form's open event check the path to the database and if the path is not what you expect, display "you are not authorized." and shut down or open the normal starting form.ģ. I think in this particular case, you can control the app without too much trouble.ġ. PS My skills are fairly basic too I can do tables/queries/forms/reports, but if you're going to give me some code, please tell me where to stick it If this is completely along the wrong track, I'd be grateful for any advice anyone can offer. "Am I installed on the hospital server? If 'Yes', OK - activate database, If 'No' display suitable message and close down".
Access database prevent display menu code#
I don't need to turn it into Fort Knox, as I get the feeling his IT skills are FAIRLY basic, but is there some way of putting some code in that says something like: Now I'm concerned that he'll take my database and use it at other customers' premises and I want to prevent that. Now I find out this guy doesn't actually work for this hospital, but is a fire safety Consultant, who has an ongoing contract for half-a-day per week, charging Lord only knows how much. I've almost got this ready now and I'm pretty happy with it.

I work in a hospital and we have a fire safety officer who has asked me to build a fairly simple database so he can log details of his audits for each ward/dept.

Access database prevent display menu how to#
Maybe this is the simplest thing going, but I have no clue how to begin.
