Technical Support

IT Related Frequently Asked Questions.

Technical Support

In the network version of ShopClock each client uses two databases: a local database which stores settings unique to each client, and a network database which stores the actual time card data. Neither data nor settings are stored anywhere else.

ShopClock uses Microsoft SQL Server Compact as its local database. This is installed as a prerequisite, and  is the only database that is used when ShopClock is configured in “Single Computer” mode.  

When configured in its “Net Work” mode, ShopClock also uses a named instance of Microsoft SQL Server Express, which is usually located somewhere on the same Local Area Network. ShopClock can also connect its network server from a remote location via a VPN connection.

Almost all of the IT issues involve not being able to access one or the other of these databases.

How to setup the ShopClock Server

If you are setting ShopClock up on a network, the place to start is on the server. That way the ShopClock clients will be able to find and login to the server by themselves when they are started for the first time.

Read More

How to move the Network database to a new server

Here are the 7 steps to "server-moving" happiness:

Read More

Customizing the MSSQL installation.

By default the network version of ShopClock uses a named instance of Microsoft SQL Server express which is installed on drive C as its network server.

Read More

How to Backup and Restore the Network Database

How ShopClock's backup system works.

Read More

How ShopClock Clients Connect to the Server

ShopClock clients look for an active ShopClock server the first time they are started. If it finds the server it connects to it. If not ...

Read More

How to connect ShopClock to a different server

This is how to "re-point" ShopClock to the new server when it wants to connect to the old server.

Read More

Problems Accessing the Network Database

When ShopClock starts up it looks in it's local database for the name of it's network server. If it finds a name, it tries to connect to that server.  If it cannot connect to that server, it displays this error message, and then quits.

Read More

Problems Accessing the Local Database

When ShopClock can't access it's local database, it displays an error message to that effect and then quits.

Read More

Running ShopClock from a Limited User Account

ShopClock does not need to be run with Admin Privileges, but the the local database needs to be accessible by the limited user.

Read More

Is ShopClock3 still available?

If you are still using Windows XP, you may want to use ShopClock3

Read More

Are .msi versions of the ShopClock Setup files available?

Yes

Read More

Will ShopClock run on a Mac

Yes, according to Scott, one of our valued customers and a long time ShopClock user.

Read More

Using VPN to connect to Remote Locations

ShopClock can be used in remote locations by connecting the locations to a common database via a VPN connection. 

Read More

Download the ShopClock Network Server

Download and install the ShopClock network database on the computer you will be using as the ShopClock Network Server.

Read More