Creating an example database

After you log on to a security file, you can create a new database.

About this task

Every iBase database contains several types of information, such as:

Database management information
Information on statistics and access control to the database. The statistics are held within the database. The separate security file can be used to make access control unique to one database or consistent across several databases.
Entities and links
iBase stores data that is organized as entity and link types; link types define the relationship between entities. Fields are the basic building blocks of the data, and their types vary in complexity.
Note: Each entity and link type has a separate table in the database. Entities and links are stored as records in those tables.
Folder objects
Folder objects support the use of the database, for example, browse definitions, labeling schemes, sets, and queries.
Data sheets
You can define data sheets to enter specific types of data.

To create an example database:

Select Create New Database and click OK.
In the Name box, enter a name.
For Database Type, select MS Access.
Choosing MS Access simplifies the initial setup of a database. However, you can create an SQL Server database. For an SQL Server database, you must specify how to connect to the database server. If you know these details, you can choose to create an SQL Server database now. If you do not know these details, create an MS Access database and then convert (upsize) it to SQL Server later.
Click OK to create an empty database with the name you have entered.

iBase Designer creates a database file with extension .idb in the folder that contains the security file.

For Microsoft™ Access databases, this file is the actual database.
For SQL Server databases, this file is a connection file to the actual database that is managed by the server.

The configuration options for security files and databases are described in Configuration Options for an iBase System.