OnLAN Messenger Administrator Manual - Using Microsoft Access to manage the database

OnLAN Messenger Administrator Manual

Introduction Contents and system requirements Terminology Installation and setup
	Loading the server Setting up the OnLAN Monitor module Setting up the OnLAN Server module
		License activation Setting the database file path Saving data to the database Setting up the main parameters
	Loading the client Client setup Advanced setup
		Choosing the network interface Registering debug information
Management tools
	Managing the OnLAN Server Managing the OnLAN Messenger
		Control console
		Testing the server Testing the client Managing online users Modifying the database
			Modifying group policies Modifying standard groups Modifying user registration data Using Microsoft Access to manage the database
		Authorizing new contact creation Managing active http-sessions Audit tools
			Managing logs
				Event log Command history Message history Unsent message log Unsent message status log
	Managing data through the web-interface
Updating and deleting
	Updating OnLAN Messenger
		Refreshing the license Updating the server version Updating the client version
	Deleting OnLAN Messenger
		Deleting the client Deleting client groups Deleting the server
Appendix
	Event log-files Codes in use Ports in use Group policy keys

Using Microsoft Access to manage the database

Modifying the database by means of the OnLAN Server interface is preferable, due to the fact that this method leaves little room for error. However, OnLAN Messenger service also supports a less safe method of modifying the database file usersdb.mdb directly from Microsoft Access.

Firstly, you need to stop executing the current database, in order to use this method. To do this, select "General" -> "Stop database execution" in the "OnLAN Server" window (pic #3). Once you're done modifying the database, you need to re-establish database execution by choosing "General" -> "Start database execution" in the "OnLAN Server" window. After that, you need to send the refreshed contact list to the clients. Select "Users -> Send contact list to all" in the "OnLAN Server" window, in order to do this.

If the changes that you're planning to make do not create or delete any existing records, only modify existing ones, then you can carry them out without pausing the database execution. This way, you will have to manually form the new contact list and send it to all active clients. To do this, select "Users -> Reload user list" in the "OnLAN Server" window, and then press "Send contact list to all".

Back Next