Kwik-Pay allows you to create multiple payroll databases, where each database contains all the information required to process a payroll for one company.
A payroll database can be created in a Microsoft Access database file (the default for Kwik-Pay), or in a server based database hosted by Microsoft SQL Server. Kwik-Pay utilises a 'udl' file to define the connection to the server. The 'udl' file contains enough information for Kwik-Pay to establish a connection to the server. Note that the initial database creation must be completed by a user who has administration rights to the SQL Server. Kwik-Pay Payroll will create a database, and create all the tables and indexes directly. Note also that when a new release of Kwik-Pay is installed, the first user to run Kwik-Pay must be a user with administration rights, because Kwik-Pay payroll may try to update table structures directly.
In the File Save window that is initially displayed when you select 'New Payroll' , select an 'mdb' file type if you want to create the Kwik-Pay payroll oin a Microsoft Access database locally on your computer. Select a 'udl' file type if you want to create the Kwik-Pay database on a SQL Server database server on your network.
The mdb or udl file will be saved in the directory last used to save a Kwik-Pay database. If this is the first Kwik-Pay database you have created, Kwik-Pay will default to the Windows application data directory. The location of this directory will vary between different releases of Windows. On Windows 2000 it is 'C:\Documents and settings\your login name\Personal\Application Files\Kwik-Pay\Payroll', where 'your login name' is the login name you used to login in to this computer.
Select Open Payroll to open a pre-existing payroll database, created as either a Microsoft Access file or on a SQL Server database server.
In order to complete the Data Link form, you will require from your SQL Server database administrator the name of the database server, login name and password.
Click on the 'Provider' tab first, and the select the 'Microsoft OLE DB Provider' for SQL Server, and then click 'Next >>'. In the server name field, enter the name of the network computer that hosts the SQL Server database, the login name and password allocated by the database administrator and the database name.
Do not click on the 'Test Connection' button yet, because the connection will fail because the database has not been created yet.
If you click the Yes button, a file open form will be displayed. The file type lists the payroll database types from which data can be imported. Select the file type you want and then browse to the folder that contains the file you wish to import. When you open the file, Kwik-Pay will copy the data from the payroll, including all leave and pay history where it can.
A progress form will be displayed as the import proceeds. There may be some delays for several minutes (or even hours for very large databases) as payslip history is imported. For payrolls of a few hundred employees or less, the process should only take a few minutes. For very large databases, you might like to monitor the progress using tools to view the database directly.