Database Registration

Upon installation, SuperPro Designer automatically registers four of the databases with the operating system as named data sources and makes them immediately available to the application. Each data source is assigned to use its own file. All files are password-protected and they are originally (by installation) located in the same folder (‘DBases’ under the auxiliary installation directory). If the database files are moved to another location or their file name is modified or the password is changed or an alternative database file is to be used, you should inform the program accordingly. You should also inform the application if you have purchased (or have at your disposal already) the full DIPPR database; Similarly, if you own a licensed version of the PPDS Suite of applications you should also register the Pure Component and/or the Binary Interaction Property ‘PPDS’ databases. To accomplish any of that, select Databanks } Availability, Passwords, & Locations... from the main menu and provide the new information in the Databases: Availability Password & Locations Dialog that appears. It is the responsibility of the users to make sure that the password recorded within the application matches exactly the password of the corresponding database files. Otherwise, the application will not be allowed to open and access the databank of information contained in the files.

Database Passwords

The database (MS-Access®) files supplied with the program are all protected with a password:

for Designer (or System) Database

Please contact Intelligen, Inc. (if needed)

for SuperPro (User) Database

“changeme”

for Process Database

“changeme”

For DIPPR DB

Unknown

Every time the application accesses any of the above files, it needs to use the correct password. All of the above files can be opened directly from MS-Access® 2007 (or later). Since we do not assume that you should modify the ‘Designer’ or the ‘DIPPR’ database, their passwords are not revealed. You should receive the password protecting the ‘DIPPR’ database once you have purchased the full version. The only other file that you may want to modify from the MS-Access® development environment (or using a third-party utility) is the ‘SuperPro (User)’ database file (and for that the password is supplied, see above).

If you open the ‘SuperPro (User)’ file with MS-Access® and change the file’s password, you will have to inform the application about the new password, otherwise SuperPro Designer will not be able to open the file and access its contained databanks when needed. For example, when attempting to register a pure component that you know it exists in the ‘SuperPro (User)’ databank, SuperPro Designer will be denied access to fetch its properties. The same holds true for the ‘DIPPR’ (full version) relational database. You must visit the Databases: Availability Password & Locations Dialog and from there the Update Database Password Dialog to inform the application about the new passwords. A password may be provided even for the ‘PPDS’ databanks if those database files are password protected.

Changing A Password from MS-Access®

If you wish to remove or change the password of the ‘SuperPro (User)’ database, you must first open the database (with exclusive rights) in MS Access®. Start then MS-Access® interface and then select the File } Open menu option. After locating the database file in the file selection dialog, select the option Open Exclusive in the combo box located in the bottom-right corner of the dialog. After providing the current password and gaining access to the database, select Info from the File menu, and then Decrypt Database. You will be prompted to enter the current password. The current password will then be removed. After this is done and if you wish to set a new password, select again File } Info, then the option Encrypt with Password and provide the new password.

IconInfo.bmp 

   In order for SuperPro Designer to be able to access the databases at run-time, it needs to be informed about the updated passwords. To do that, run SuperPro Designer and select Databanks } Availability, Password & Locations. In the Databases: Availability Password & Locations Dialog that opens, press the Password button in the affected database section and provide the new password. If the password of the database has been removed (i.e. the database is no longer password protected), leave the password box blank and click OK. Note that changing the password through SuperPro Designer alone, does not automatically change the password of the database file itself. You have to go through MS-Access following the process described above.