island with question mark

Column not found: ACC_Recid on Workstation

This image has an empty alt attribute; its file name is Column-not-found-error-e1431104244714.png

What does this error mean?

This error rarely has anything to do with the software itself. It means the program can’t connect to the TimeClick database located on your server and is generally due to a change in your computer or network settings or a network connectivity issue. The most common causes and fixes are:

  • The IP address of the TimeClick server has changed
  • The firewall on the TimeClick server is blocking the connection
  • Antivirus software on the TimeClick server is blocking the connection
  • The workstation computer is not on the same network as the TimeClick server computer

The IP address of the TimeClick server has changed

Before starting these steps you will first need to get the internal IP address of the TimeClick server. If you don’t know how to get that, here is a link to one our article about getting the IP address of the server.

  1. Using the Windows search bar on your TimeClick workstation computer, type in client config
  2. Click on client config which should then open TimeClick Client Configuration
  3. Click change
  4. Enter the IP address of the TimeClick server computer, if you don’t have it follow these instructions on how to get it.
  5. Enter the default port 12010
  6. Click connect
  7. Try opening TimeClick, if the error message persists continue to the next set of instructions

The firewall on the TimeClick Server is blocking the connection

  1. Go to the TimeClick server computer, (the one with the gray TimeClick icon)
  2. Using the Windows search bar, type in windows defender firewall with advanced security then click on the top option
  3. Select inbound rules on the top left
  4. Click create new rule on the right side
  5. Select Port and Click next
  6. In Specific local ports type in 12010 and click next
  7. Make sure Allow the connection is selected and click next
  8. Check the boxes Domain, Private, and Public and click next
  9. Type in the name TimeClick and click finish
  10. Select outbound rules on the top left
  11. Follow steps 4 – 9 for creating a new rule for outbound rules
  12. Try opening TimeClick on the workstation that was giving the error

Antivirus software on the TimeClick server is blocking the connection

All antivirus software is different and requires hands on work to modify and fix it. We recommend that an IT person or administrator who is familiar with your antivirus software make the modifications. Similar to the windows firewall instructions the IT person or administrator will need to make an exception for the port 12010 which is the port TimeClick uses to communicate.

The workstation computer is not on the same network as the TimeClick server computer

TimeClick communicates through the local area network. That means that TimeClick will not be able to communicate between locations unless an IT person sets up a special VPN to tie all the locations networks together. For solving this problem we recommend having an IT representative look at your network and troubleshoot why your computer is not able to communicate with the TimeClick server computer.

Bobby Gailey

Bobby is Head of Sales and Customer Success at TimeClick where he enjoys helping current and aspiring time trackers solve problems. At home, he loves spending quality time with family and friends and nerding out over tech and video games.

Face Payroll Like a BOSS.

No Credit Card Required. Fully Functional For 14 Days.