Skip to main content

Windows Team Clients

When using Data Entry Forms through the Windows Team Client, there are a few things that need to be considered.

Database Access

Depending on the database used to store the form data, considerations need to be made to ensure that the database is accessible from the Windows Team Clients.

Microsoft SQL Server

Connectors defined to SQL Server can be done so by either using Windows or SQL Server authentication.

If Windows authentication is selected, the current Windows user is used for the connection. From a Windows Team Client, this user is defined for the XLRwebpool Application Pool as defined in the Internet Information Services (IIS) Manager where XLReporter is installed. By default, this is a very low-level built-in user, but can be changed if needed. For more information, see Setup the Web Portal.Web Portal

SQL Server authentication has no dependencies on the Windows user at all.

Microsoft Access

Connectors defined to Access define a file located somewhere on the local machine or network to store data.

In order for Data Entry Forms to store data to this database, the Windows user must have write access to the file. From a Windows Team Client, this user is defined for the XLRwebpool Application Pool as defined in the Internet Information Services (IIS) Manager where XLReporter is installed. By default, this is a very low-level built-in user, but can be changed if needed. For more information, see Setup the Web Portal.Web Portal

The options are either to set up the Windows Team Clients to run under a specific user and give that user write permissions to the database file or to give Everyone write access to the file and not change the user.

Offline/Out of Network Range

In order to access Data Entry Forms from a Windows Team Client, the machine must be connected via network (either wired or wireless) to the machine where XLReporter is installed.

Once logged in and the Data Entry Forms application is opened, if the network connection is lost, the ability to change forms or store data is disabled. However, the currently selected form will remain opened, and data can be entered on it.

As long as the application remains opened, no data entered will be lost. Once network connectivity is re-established and you are logged back in, you can then store the data from the form back to the database.