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.

In this procedure we will find the original patient number, add a new patient, change the patient number to the original number and re-index.

1.  Find a clinical record number

Open Microvet

Click PATIENTS

Click CLINICAL RECORD

Click EDIT CLINICAL RECORD

Find a clinical record for the archived patient and get the clinical record number.

2.  Add a new patient

Add a new patient in Microvet in the usual way.  Fill in all the detail of the archived patient.

(The patient number will be a new number but we are going to change it shortly.)

3.  Get the original patient number

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 CLINICAL.DBF

OK

F5

Database

Look at the CLNUM column

Page down and find the clinical record number obtained in step1.

Get the CLDPNUM.  This is the original number of archived patient

ESC

4.  Change the patient number

You are still in DBU after step 3.

F2

DATABASE

Open DEPEND.DBF

OK

Page down to the bottom of the file.  The last record will be the record that was added in step 2.

Change the DPNUM value with the number obtained in step 3 (original patient nr.).

ENTER

ESC

ESC

EXIT TO DOS

Y

DEL  *.IDX

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