Sharing and Maintaining the Database
The following questions are addressed here:
See also the following Troubleshooting Tips:
The database file is called CDB.MDB. It is initially installed by default in the program folder, normally C:\P-Closer, but it may be placed elsewhere.
Right click Power Closer (house) shortcut and
select Properties. On the Properties screen, note the "Start In"
location. That is where Power Closer expects to find the database file CDB.MDB.
Power Closer Jr. and Standard can share the same closing database one user at a time. Upgrade them to Power Closer 2-User Site to enable two users to access the database at the same time. Add Additional Users as needed for additional simultaneous users.
Always install Power Closer at each workstation as if it is to be run standalone, even if you plan to network it. If networking, share only the closing database file CDB.MDB. In other words, each user should run a separate copy of the program executable file located in its own separate program folder.
To share the Power Closer database
over a local area network, continue with the following sections:
The Power Closer database may be located where it can be backed up conveniently and accessed by the appropriate users.
Always install Power Closer normally on each workstation as if it is to be used standalone, even when sharing the database. Share only the database file.
Decide where the database ought to be located, as described in the preceding section.
Copy the database file CDB.MDB to the desired location.
If you are replacing an old computer with a new computer, and want to use the database that was on the old computer, see also: To restore a database.
Right click the Power Closer shortcut (house image) on the desktop and select Properties. Change the "Start In" location to the new location of the database. Do this at each workstation which is to use this database.
If the same
database is being used by several workstations, run Power Closer from one workstation. Make a
test data entry. If running a single-user version of Power Closer that
cannot share the database simultaneously, exit
Power Closer. Run Power Closer from the other workstations and verify
that they can see and edit the test data entry.
Power Closer Standard Single User and Power Closer Network Site have an Archive capability which can consolidate databases by archiving several databases to a single archive and restoring that to a single database. Alternatively, create separate archives for each database, but restore them all into the same database. The Archive capability is a function of the Database Manager program normally at c:\P-Closer\db-mgr.exe. It requires exclusive use of the database.
If you have more than one version of the same closing file in several databases, take care to
determine which is the current version of the closing, and develop a strategy to arrive
at the correct result. The Archive Utility will ask before overwriting an
existing closing, but will not help you decide which is the correct version. For
example, you may choose to copy into the database a batch of closings that
include some old versions first, and then copy in a batch of closings that
contain some newer versions of the same closings, so that newer versions replace
Power Closer's Database Manager can compact and repair the database. It is located in the program folder, normally located at C:\P-Closer\db-mgr.exe. All users must exit Power Closer before you compact or repair.
It is a good idea to compact the
database occasionally immediately after backing it up. For example, you might compact it each time you have
created another 100 to 200 new closing files in Power Closer. In the unlikely
event that compacting the database discovers errors, see "What
is corrupting the database?" (Troubleshooting)
Set up Power Closer so that the database is located where it can be easily backed up. For example, you might place the database file on a server that is already being backed up automatically at night. Be sure everyone exits Power Closer at the end of the day if you do this. See Choose a location for the closing database file.
If you do not have an automatic way of backing up the database at a time when Power Closer is not in use, you may want to use Power Closer's database backup feature.
To back up the database manually: