Access database

previous  Top  next


We recommend that all users who have little or no experience of administering databases to run Untis MultiUser with Microsoft Access.


Perform the following steps to use Untis MultiUser with a Microsoft Access database.



Please visit our homepage for the Untis.mdb file: . Copy this file to a folder on the server to which all users have read and write access.


In the following steps we assume that Untis MultiUser has been properly installed using administrator rights on each computer where the program is to be used.


The following steps must now be performed on each of these computers:


Windows 8 and Windows 10:


1. Search via the start screen the appropriate ODBC Connector.





MU_19_003                        MU_19_004


                 2. Select the required ODBC Connector.


3. Now continue with item 4 of older Windows versions.


older Windows versions:


1.Open the control panel of the computer.



2.Double-click on item 'Administration' to open it. Depending on your Windows settings, you may also find this item under system and maintenance.

3.Double-click on item "Data Source (ODBC)".

4.A dialogue appears in which all created data sources are listed. We now want to add the data source for Untis. To this end, click on the <Add> button.
If the ODBC connection is to be created only for the currently active Windows user, use the "User DSN" tab. If you wish to create the ODBC connection for all users, use the "System DSN" tab.


5.Select "Microsoft Access driver (*.mdb)" from the list of drivers presented and click on <Finish>. In case the driver is not listed, you can download it from the Microsoft website (search for "MDAC").




6.A dialogue appears in which you can specify the database to which it is to be connected to and which name it should have. The data source name must be "Untis" unless defined otherwise in the corresponding settings in Untis. If you want to read more about the ODBC names go to chapter Variable name of the ODBC connection . You can use the <Select> button to specify the path that leads to the Untis.mdb file on the server.

7.Confirm all dialogues with <OK>. Installation is now completed.




If you are working with a 64-bit operating system, please read the chapter of the same name.


You can now skip to item Launching Untis MultiUser for the first time.