Home >FAQ >Folder HelpDesk kalmstrom.com site map icon Site map  

kalmstrom.com FAQ – Folder HelpDesk


Type Errors

Problem Work done tab: I get an error when I click on the Add button in the ticket form "Work Done" tab.

Work done tab: I get an error when I click on the Add button in the ticket form "Work Done" tab.

ERROR
This error has occurred:
Attempting to open a recordset from Select * from tblWork where intTicketID = 32815
The system error message was: : Multiple-step operation generated errors. Check each status value.

SOLUTION
This problem in the database comes when the limit of the column "intTicketID" in table "tblWork" has been exceeded. Folder HelpDesk has been updated so that new users will not have this issue anymore, but unfortunately it cannot be done automatically for older installations.

To solve the problem you need to change the data type of the column "intTicketID" from smallint to int.

Please make sure that no one else is running Folder HelpDesk when you are trying to change the datatype.

This is the process:

SQL Server database
  1. Open the SQL Server Management Studio.
  2. Open the Folder HelpDesk SQL database.
  3. Open the table "tblWork" in design view by right clicking.
  4. Change the datatype of the column "intTicketID" from smallint to int.
  5. Save the table and then try again.
Access database
  1. Open the Folder HelpDesk database "PFHelpDesk.mdb".
  2. Open the table "tblWork" in design view by right clicking.
  3. Change the datatype of column "intTicketID" from smallint to int.
  4. Save the table and then try again.
Products Buy FAQ Services Tips Education Contact About Us Blog

  Security and integrity

Copyright  Kalmstrom Enterprises AB  All rights reserved