Denys Beauchemin writes: >>> Denys Beauchemin <[log in to unmask]> 05/07/98 12:01pm >>> X-no-Archive:yes There are three (3) valid values for the mode parameter of the DBCLOSE call. Mode 1, close the database, if you are the only one accessing the DB at that time, it also purges the DBG, along with all the buffers in use by IMAGE for that database. If you are not the only one using the database when you close it, DBCLOSE mode 1 purges the buffers reserved for your process, releases all the locks your process may have in the DB, and decrements the users counter by one. You use mode 1, when your process (program) has finished accessing the database, usually at the end of the program. It's a nice clean way of programming. Your program doesn't really have to use DBCLOSE, because MPE will close it for you when your program ends, but you should use DBCLOSE, mode 1. < balance snipped > ------------------------------------------------------------------------------------ Denys is absolutely correct, however there are times when you want to explicitly issue a DBCLOSE mode 1. If you open a data base each time you enter a called subprogram, and fail to DBCLOSE it before exiting, you will soon hit the limit of 63 DBOPENs of a data base. It is probably better that you pass the opened base parameter around from main to subprogram and back in the passing parameters and avoid the extra DBOPENS. Mike Berkowitz Guess? Inc.