Backup Database ACCESS Database SQL Import/Export Login Reset

XT Admin helps you to configure your database:

You can:

1. setup the connection with following servers:
• Access
• MS-SQL-Server 
  
 
2. Set the login mode for users
   
 
3. Reset all database tables to setup a new database
   
 
4. Import or export your database
   
 
5. Backup the data. 

Only the administrator should have access to the database. Changes can affect the whole Xpert-Timer system.

At the bottom there are several buttons available.

Usually the database updates itself as soon as a new version is installed. If you happen to notice, that the patchlevel of the database is different to the one of the program, hit the button "Update DB structure".

Sometimes Xpert-Timer gets stuct while patching the database. Use the button "Set patchlevel" to set the patchlevel back to a lower number and try to update again.

Use "Switch from Access" if you tested the Xpert-Timer with an ACCESS database and you don't want to loose the date. You can import the files into an SQL database.

Set a server IP in order to keep track of the connection to the database. Xpert-Timer will then notice if the connection is lost and reconnect after it found the connection again.