Finding the location of, and connecting to your VisitorRego database can be done via the Database tab.
To access this, from VisitorRego'sAdmin mode, chooseOptions> System Setup> Databasetab.
Under the Databases tab there is a field labelled'Database Engine' which is used to switch between the two database modes;SQLandMicrosoft Access.
Choosing either of the two will automatically show the options associated with each one.
This is the default setting. VisitorRego is distributed with a local Access database for ease of install and trialling the software.
The Path of VisitorRego.mdb shows the location of this database file.
SQL using Windows Authentication
SQL is the preferred database engine. If the company doesn't already have an SQL server, then SQL Express can be downloaded and installed free from Microsoft.
Note:you can only use an SQL database if you are running VR - Professional.
SQL using SQL authentication
Many companies are concerned with security, especially connecting a workstation to their network that is used by the public. If this is the case the workstation used by the public can be cabled to the network but authenticate against the domain. VisitorRego can then access the SQL database on a back end server within the domain and it only authenticates against this server using SQL authentication.
Changing databases requires VisitorRego to close the current connection and reopen the new connection. Click'Apply' to make the changes to the configuration file. When the System Setup screen is closed is the time when the new database connection will be opened.
It is good practice when ever changing a configuration setting, to stop and start VisitorRego The changes are only written to the configuration file when VisitorRego is stopped.