Creation of commercial exhibits in Access
Creation runtime exhibits
Transformation of the interface in MDE (ADE)
For spreading the program with closed by programme code is used transformation of the file of the project in format MDE or ADE. Accordingly do not use in code of the programs to operations inadmissible in MDE-file. Much neatly use the references (References), in MDE-file to install their programme way will not manage. Besides, on own experience of the functioning, Access not always correct restores the references to library files of the various versions. In particular because of problems with functioning under various versions Microsoft Office, in development of our companies is not used reference to library Microsoft Excel Object Library. Instead of this in all operation of the exchange given with Excel is used type Object and later collecting (CreateObject( Excel.Application )). Wake certain that program of the installation of your application will place the library files (ActiveX, DLL, superstructures) exactly in that file (on types: system, programme, Office\Library etc.), where cited the main file of the project before transformation in MDE/ADE.
Access Run-time
ODE version comprises of itself program for preparing the mounting package (Package Wizard), in which can be included run-time version Microsoft Access. This program spreads together with final application Access on licenses ODE and allows to start the files an user, not having предустановленного package Microsoft Office Professional. Run-time version Access - a set performed and library files moreover some absolutely identical usual version Access (for instance, msaccess.exe), other differ and on contents, and on names (msoX.dll and msoXrt.dll). Install Run-time version manually it is enough in a complicated way. As from versions 2002 Package Wizard forms separate msi file Access Run-time for installing by means of WindowsInstaller a. For previous version run-time version also was available in the manner of usual setup-file. Run-time version several differs from standard: in particular is absent the window a database, not available no facility of the editing project, no standard panels instrument. I never also did not hear of localized run-time version Access (ODE does not spread with russian localization). Wake ready to that that all system messages it is necessary or change, or give in with that that they will be removed on english (for instance, text in status line).
Testing of exhibits in Run-time
Testing of ready exhibits necessary to produce exactly in run-time versions. The separate computer will be necessary For this sooner whole without предустановленных office programs. The Command line Access offers use to options /runtime for testing of applications. Do Not use this possibility, since behaviour of application and results of the functioning in persisting run-time versions can differ!
Standards for клиентских of exhibits
Are they Here enumerated standard interface facilities, doing клиентское application friend user.
Logo
Application must have a logo with name of the program, author's копирайт and year (the date) of the issue , number to versions. If program has a system to registrations, that must be выведена information on authorized user and type to licenses. Information on author must be also available through menu and reference system.
Ikonka for windows
To greatly hide the origin of the program and facility of her(its) development, makes sense change the иконки for the forms and reports of application. The characteristic of the start use For this possible in menu Access, or adjust the иконку through call API-function at opening window.
Menu, panels instrument
Use all possibility (not much, apropos, богатые) for development of the friend interface of the user. Change the standard menu on own, develop the panels an instrument and contextual menu.
Reference system
The Development of the reference system and kit to user documentation deal certainly непростое, but obligatory. Contextual calling the reference possible to adjust through call function libraries "hhctrl.ocx" (HTMLHelpStdCall).
The Compiler help-files bes included in ODE.Facilities of management database
Comprise of composition of the package of the program of the facility of the service database and interface file. This can be a protozoa of the program on reserve copying, reconstruction, compression database and interface file.
Making the program of the installation for complete applications
Program of the installation
The Program of the creation mounting package Package Wizard, being included in ODE, capable to do setup-file for your application. But on all review and on own experience of the possibility and result of the functioning of this program absolutely not that that wanted see. This program (the versions ODE2002) does not support russian adjustment Windows, does not allow to adjust the algorithm of the installation, and even refuses to create the archive on disk with file system NTFS! Thereby, urgently is not recommended use this program for spreading of own applications. The Main that possible to take after functioning(working) Package Wizard, this msi-files for Access Run-time and Microsoft Desktop Engine. Develop the program of the installation possible in any инсталляционной to system, for instance, InstallShield, Wise. In this case it will take to adjust these program for calling msi-archive from command line. The Foreign developers much recommend the program SageKey, specially adjusted for work with applications Access. Our company uses liberally spread program InnoSetup
Making the label for start of exhibit
Using any program of the installation do not forget to indicate the full way of the start in label of application, for instance: C:\Program Files\Microsoft Office\Office\msaccess.exe C:\MyProgram\MyProgram.mde /wrkgrp C:\MyProgram\MySystem.mdw.
Renovations
At supply of the multiuser version of exhibit makes sense think about method of the installing the renovations with united server. The Program (and possible database) must keep the number to running version (in own code or in external file on computer of the user) and check when start presence renovations on server. The Similar image possible to organize the procedure of the compression of the interface, automatically checking size of the performed file.
Restrictions
Is it Here described reasons, which can serve for refusal of Access at choice of the facility of the development.
Unauthorized access
Regrettably, exhibit Access practically impossible to protect from unauthorized access to given хакерскими methods. In интернете have got broad spreading the program for взламывания passwords of the files of the working group and database.
Cardinal output remains the cryptooperation data, but herewith it is necessary to change whole managerial system and abandon to relational model. That, in my opinion, absolutely inadmissible. Apropos, from possible losses of information (for instance, intentional removing) cryptooperation also can not protect.
In connection with foregoing certainly does not cost(stand) to develop on Access applications, processing confidential given (bank, accounting, биллинговые etc.).
On own experience in 9 events from 10 is not required global system of protection of applications from хакерских of attacks. Besides, losses from invalid action of the users with authorized access can be even above, since bring about hidden error. However provide the minimum necessary level of protection given certainly necessary. Hereinafter list action is brought for ensuring such level to safety:
- Adjustment option start ( protection from Shift ).
- Adjusting the rights on objects at a rate of server and/or file of the working group.
- Ensuring the input in application with instruction of the password only.
- The Connection when entering and unhooking when leaving линкованных tables in project MDB/MDE.
- Adjusting the automatic procedures of reserve copying given on server.
- Conduct journal change critical data.
Рекомендуется создавать отдельный файл рабочей группы (первоначально скопировав system.mdw), затем запускать приложение через использование опции командой строки «/wrkgrp».
In general-that in development of our companies is not used delimitation of the access through standard functions of the working group Access. On many reason it happened to to develop the own module of the adjusting the users and groups. So value work with standard system of the delimitation of the access to object and given I, regrettably, can not. In detail about safety and delimitation of the access refer to
Hidden mistakes Access
Either as any system of the development, Access, contains the mistakes in own programme realization. Their amount increases or grows shorter in connection with issue of the various versions and service-ration. In spite of presence such mistake and недоработок, as a whole Access under correct use it is enough firm system. But amount incurable or unexplained mistake in general exceedingly little. In 99% so named errors Access are indeed connected with wrong algorithm or programme code.
In our development appeared following complex for eliminating the problem:
- The Full destruction mdb-project without possibility of the reconstruction at import object without the following compiling. Dares reserve copying and keeping object in text type.
- The Loss of the references when use the libraries of the various versions. Dares through use the type Object and later collecting.
- The Mistakes when work with ActiveX. For instance, invalid hierarchy data sheet TreeView if tree is not displayed on the form at present. Here in each event it is necessary to understand apart.
- The Loss of the point user menu. It Dares through programme creation menu and panels instrument.
