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.

This is mostly a small problem, but it could also be an indication of a bigger problem. First try the following two solutions and if that does not work you can look at solution three and contact us.

1.  Re-index

Exit from Microvet on all the computers including the file sever

Go to the file server

Open Microvet

Click on FILE

Click on RE-INDEX

2.  File maintenance

If an ordinary re-index does not help, run the file maintenance.

Exit from Microvet on all the computers including the file sever

Click on Start

Click on RUN

Type in:

      C:\MFW5\MFW5MAIN.EXE

OK

This will start the file maintenance

Answer Yes to all the questions

If you get an error message “Accounts.dbf does not exist”,

close all the programs en restart the computer.

Try again to run the file maintenance

Wait for the procedure to return to the Windows desktop.

Open 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

3.  Record counter

If you still get the message, there can be a bigger problem. There is a counter that keeps track of the record numbers. Each table has a record number field. These record numbers are unique numbers. The name of the field starts with two letters that refers to the table followed by ‘num’. The record number field for stock is ‘stnum’ and for services it is ‘srnum’. If the record counter has a problem, it is possible that records with duplicate numbers may be created. This can cause big problems. There are more than 40 tables in Microvet. It helps if you know where start to look for the problem. The task that you were busy with when the error occurred is the clue. If you were adding a client when this happened the problem is in the client file. Investigate the problem as follows:

Exit from of Microvet on all the computers

Make a backup

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

(From now on you will not be able to use your mouse, use the Enter key and the arrows on your keyboard.)

Type the following:

CD\MFW5

DBU

F2

DATABASE

Exit from of Microvet on all the computers

Make a backup

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

(From now on you will not be able to use your mouse, use the Enter key and the arrows on your keyboard.)

Type the following:

CD\MFW5

DBU

F2

DATABASE

Open the table that you want to inspect (ACCOUNTS.DBF in this case)

F5

DATABASE

Look at the record number field, ‘acnum, in this case. The records number should increase one at a time. There may be numbers missing. Page down and scroll to the end of the table. The problem that we are looking for is where the number jumps back to a smaller number. If this problem exists, it will probably be close to the end of the table. It may be quicker to start at the bottom of the table and scroll upwards. If you find this problem, do not try to fix it yourself. Contact Otomys to help you.