Important Note: The DBU is a database utility program that you can use to manipulate data directly. Great care should be taken when working in the DBU. You may cause irreparable damage, delete or change data if you do not know what you are doing. Make a backup before you open the DBU. Please follow the instructions very carefully. If you are unsure of any instruction please do not hesitate to contact Otomys directly at (012) 348 4071. Otomys will not be held accountable for any data loss or corruption.

The age-account part of MONTH-END (BEFORE STATEMENTS) relies on unique account numbers. If there is a duplicate account number, the process will stop at this number. It may give a message like this "record is out of range" and then it freezes. The account number is displayed on the status bar at the bottom left of the screen. It may say "ageing account 1223". In this case the account number is 1223 and it is possible that there is another account with the same number. This routine will help you to find this account and to delete it. There are two possible solutions.

If the MONTH-END (BEFORE STATEMENTS) gets stuck while doing account ageing, this step can be repeated after the duplicate account has been deleted. If the MONTH-END (BEFORE STATEMENTS) gets stuck while adding interest and administration fees, the backup must be restored first.

Solution 1

Stop the program

Press CTRL + ALT + DEL

Hi-light MFW5

Click on END TASK

Click on OK when it says ‘CAN NOT QUIT FOXPRO’

Wait 10 seconds

Click on END TASK

Open Microvet

Go to DELETE ACCOUNT

Change the index so that the account numbers are listed on your left.

(Click on the <I> button until the account number is listed on the left.)

Type the account number where the problem was (e.g. 1223 in this case).

Press enter and inspect the accounts. If there is a duplicate, delete one of the two accounts.

Solution 2

In this case it is assumed that you have made a backup before you started the

MONTH-END (BEFORE STATEMENTS) procedure and it is better not to repeat the backup after you have encountered the problem.

Exit from of Microvet on all the computers

Do these steps on the file server

Click on START

Click on PROGRAMS

Click on ACCESSORIES (only for windows ME/XP/NT and 2000)

Click on MS-DOS PROMPT or COMMAND PROMT

Type the following:

CD\MFW5

PKZIP   -A   DATA   *.DB?

DEL   *.DB?

DEL   *.IDX

DIR  MFW5BACK.ZIP

Look at the date and size of the file. This is the last backup zip file. The date must correspond with the last time that a backup was done. If this is correct proceed with the instructions.

PKUNZIP   -O   MFW5BACK

DBU

F2

DATABASE

Open ACCOUNTS.DBF

OK

F3

INDEX

Type in:

   File    ACNUM

   Key   ACNUM

OK

F5

DATABASE

Look at the acnum column on the left. Page down and find acnum 1223. Place the cursor on the duplicate number.

Press the delete button once.

ESC

F6

PACK

Y

ESC

EXIT TO DOS

DEL   *.IDX

DEL   *.NTX

EXIT

Start Microvet

The program will automatically start to re-index

A message may appear: ‘File is not marked with a code page’

Click on Windows

The selection will go to Windows ANSI

Click on Select

Log in

Repeat the Month-End (Before Statements) procedure