SuSE Support Database

Title: LNX: Creation of a table with LNX

---

Mainpage ---- Searchform ---- History ---- Versions ---- Categories ---- Contents
Deutsch
---

LNX: Creation of a table with LNX

Applicable to
S.u.S.E. version: 4.4
LNX version: 3.5

Question:

How can I create/change a table under MS Access.

Answer:

This is not possible in Access because Access cannot create or change any integrated table. Only values within an integrated table can be changed.

You could indeed create the table with a query in Access. Query / new / table model . Now look for the option Sql in the menu. Delete the lines that are already in the window and set a SQL command to make the table.

( create table test ( sp1 char (10),sp2 integer, sp3 date );
Finally, you must still place a clear key:
create unique key ( sp1 )
Now you can integrate the table into Access and enter full of sense values into the columns.

---

Keywords: LNX, ACCESS

---

Mainpage ---- Searchform ---- History ---- Versions ---- Categories ---- Contents
Deutsch
---

SDB-lnx5, Copyright SuSE GmbH, Nuremberg, Germany - Version:
Impressum - Last generated: 24. Feb 1999 14:58:13 by maddin with sdb_gen 1.00.0