Do you need to log user actions and run algorithms to detect suspicious behaviour? Can users delete records accidentally? etc.ĭepending on the strategies for the 4 ' W's, it may be access is not the right thing to use. Hi all, I need to distribute 2016 Ms Access App like a on the shelf application: the customer download the autoinstalling package, then double click on it and then follows the wizard's instructions until the final installation.
You do not need to buy any special product in order to redistribute the Access 2013 Runtime. The Access 2013 Runtime is similar to previous runtimes in that all design-related UI is either removed or disabled. During Setup, this is primarily useful for extracting files that are. innoextract currently supports installers created by Inno Setup 1.2.10 to 6.1.2. innoextract allows to extract such installers without running the actual setup executable under Windows or using Wine. And then develop the appropriate strategies (plural) which will often impact on how you design the functionality of the front end.įor example, have you considered protecting against sql injection? Can users run queries/reports to display the entire customer list and contacts which they can then simply copy/paste into excel. To do so, you must package and distribute your application with the Access 2013 Runtime. All files and subdirectories in this directory are deleted when Setup or Uninstall exits. Inno Setup is a tool to create installers for Microsoft Windows applications. If you want security, you have to decide What you want to protect, from Whom, doing What and Why. SQL Server/Express provides a much higher level of security for your data - subject to your front end not allowing any more than the necessary access for users to do their work. But all that can be overcome by someone who is determined enough. MS used to have a wizard that allowed you to do that. accde in a text editor like notepad and can see all text as text. I would like to bundle the Access 2016 Runtime with my database as an executable where the user can just click the defaults and the Runtime will be installed and my database will be unzipped. And here is the function I wrote to check if it is installed: function AccessEngineNotInstalled: Boolean begin Result : not RegKeyExists (HKEYLOCALMACHINE, SOFTWAREMicrosoftOffice14.
Don't use linked tables in the front end and hide the password in your vba code in hashed form - anyone can open a. Click to expand.encrypt it with a password before you distribute it.