Creating data base with Adabas...

[ok]

I am using StarOffice 5,2 and would like to create a data base using the Adabas base, somebody could explain me as to make, step by step therefore I am trying, but, without success.

[Lee Brown]

1. Open Star Office, then click on "File>New>Database" from the Explorer window. (You can also right-click in the Explorer window and select "New>Database".) A Properties dialog box should appear.
2. Enter the name of your new database.
3. Select a database type, in this case, "AdabaseD".
4. Enter a data source for your database. (Refer to my post, "Installing AdabaseD on Windows ME (2000?)" in this forum for details on declaring a data source for AdabaseD.)
5. Click the "New Data Source" button. Adabase will then create the protocals for your new database. This will take a few moments.
6. Enter a User Name and password for your new database. (Note for single-users of Star Office/AdabaseD: DO NOT enter an Administrator user name or password. This information will be derived automatically from the User name and password you previously entered. See the aforementioned posted for more details.)
7. Click "OK". It may take a few minutes, but your new database should appear in your Explorer window. To be sure it is working properly, look for a "traffic light" next to your clock on your normal desktop. (For Windows users, this is in the lower right-hand corner of your screen.)
8. Click on the "+" sign next to your new database to expand the object folders. You should have four of them: tables, queries, reports and forms (not necessarily in this order).
9. Right-click table object to open the table object's folder.
10. Select "New>Table>Table Design". A blank table properties dialog box should appear where you can add fields.

Things of note:

1. To set an auto-number to a field that is your primary key, i.e., RecordID, use the "number" field type, and set the property to "Integer."
2. You can not "drag and drop" fields to change their placement (e.g., moving a field from the bottom to the top of your field list). The only way to change your field order is to "cut" those fields above the field you want to reposition on your list, enter the new field in the correct position, then "paste" them back into your field list. Use caution when attempting this because you could loss data, not to mention all the fields you previously created.
3. You cannot switch between "Table Design" view and "Table" view in AdabaseD. To actually see your table to enter data, you have to save your table in design mode first, exit from it, then open the table normally. Sorry...

Hope this helps!