Reply to post:

Chap joins elite support team, solves what no one else can. Is he invited back? Is he f**k

Sequin

I worked in the \iT section of a large government department and was asked to look at an MSAccess application that had been provide by an external supplier for recording sick absences in Police departments. It had suddenly stopped accepting new data and the supplier had said it would take weeks and cost several grand to fix it as nobody had taken out a support contract with them.

I asked the person who passed it to me if the record number of the last record was 32,767? How did you guess that he asked? It turns out that the record number column was defined as an integer and had reached its limit. I redefined the column as a long integer, which fixed the problem in about 10 seconds at the cost of bugger all.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Biting the hand that feeds IT © 1998–2019