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.

How to remove records from a database

This will permanently delete records from your database.

Do not do this procedure if you are not absolutely sure. You can decide which table you want to clear.

 

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 ACCOUNTS.DBF       (Clients)

F6(Utility)

Zap

 

Repeat for the following:

DEPEND.DBF      (Patients)

CLINICAL.DBF     (Clinical record)    

CLINITEM.DBF    

TRANSAC.DBF   (Transactions)

TITEM.DBF            

OLDTRAN.DBF   (Old transactions – after month end)

OLDITEM.DBF    

ARCTRAN.DBF     

ARCITEM.DBF    

CASHITEM.DBF   (Creditor transactions)

CASHTRAN.DBF   

OLDCASHI.DBF   (Old creditor transaction – after accounting month-end)

OLDCASHT.DBF   

SERVICE.DBF     (Professional fees and Services)

STOCK.DBF        (Drugs and materials)

METHOD.DBF     (Methods and combination procedures)

METHITEM.DBF     

QUEUE.DBF          (Waiting list)

 

ESC

ESC

“Exit to DOS”

Y

Type in:

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

Repeat a couple of times until the log in Window appear

Log in 

 

Click on TRANSACTIONS

Click on RE-CALC BALANCES