SuSE GmbH

SuSE Support Database

Title: LNX: Creation of a table with LNX

----------

Mainpage o Searchform o History o Versions o Categories o 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 o Searchform o History o Versions o Categories o Contents
Deutsch

----------

SDB-lnx5, Copyright SuSE GmbH, Nuremberg, Germany - Version:
SuSE GmbH - Last generated: 07. Oct 1999 16:57:41 by maddin with sdb_gen 1.00.0