Protection against unauthorised access
MySQL and MS SQL provide many possibilities to protect access to the database. Visit the vendors' websites to find out more about these.
Microsoft Access databases can also be protected against unauthorised access.
Launch the Access application and click on "File | Open". From the different possibilities to open the file "Untis.mdb" select option "Open Exclusive" (see figure below).
On the "Database tools" tab and select the <Encrypt with password> option and define a password.
You must now enter this password in the ODBC connection, as well. To do this, click on <Advanced> in the Untis ODBC connection and enter the password you defined in Access in the "Password" field. You can leave the "Login name" field empty.