feltdifenitionen driller...

I am sure you can find what you want here

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.TABLE1
    (
    col1 int NOT NULL IDENTITY (1, 1),
    col2 char(10) NULL
    ) ON [PRIMARY]
GO
COMMIT

col1 is the \"autonumber\". Autonumber is Access, in SQL its not the same.

You see...
I can creat the TABEL with the name rs(\"opretID\")
but there is something wrong in the way I try to Name the cols and claim there \"identity\"...

I can\'t read it out of your answer could you give it one more try.

strSQL = \"CREATE TABLE \" & & Session(\"opretID\") &
    \"(
    ID int NOT NULL IDENTITY (1, 1),
    budget varchar(50) NULL,
    SagNR varchar(50) NULL,
    Notat varchar(2000) NULL
    )\"

The varchar can be up to 8000 bytes and it only takes up the actual number of characters used.

text can hold  2^31 characters

strSQL = \"CREATE TABLE \" & &
=
strSQL = \"CREATE TABLE \" &

Hello terry...

One more question does this:

Notat varchar(2000)NULL - mean that this col
can handle the value NULL...

yes

But there are still problems this is what the error message is saying:

Microsoft OLE DB Provider for ODBC Drivers fejl \'80040e14\'

[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i CREATE TABLE-sætningen.

/skole/Projekt/opret.asp, linje 45

And that means : there is a syntaxerror in the CREATE TABLE-sentense

Do you know what to do...

I CAN create a table using this SQL statement. I have replaced Session(\"opretID\") with a table named Session. So all I can suggest is that you some how look at what is in strSQL just before you execute your ASP.
You can also try this:

strSQL=\"CREATE TABLE Session (
    ID int NOT NULL IDENTITY (1, 1),
    budget varchar(50) NULL,
    SagNR varchar(50) NULL,
    Notat varchar(2000) NULL
    )\"

Hello again.

It seems to me like it\'s the end of the sentense that doesn\'t work right.

if I write:

strSQL = \"CREATE TABLE \" & Session(\"opretID\")

the table will be created with a unic name for each time.

So tht part of the sentense is All Right

hmmmmmm

Try this:

strSQL=\"CREATE TABLE Session (
    ID int IDENTITY (1, 1) NOT NULL,
    budget varchar(50) NULL,
    SagNR varchar(50) NULL,
    Notat varchar(2000) NULL
    )\"

Desuden, hvis din variabel Session(\"opretID\") indeholder mellemrum og muligvis andre fancy karakterer, så sørg for at omkranse med []:

strSQL = \"CREATE TABLE [\" & Session(\"opretID\") & \"] ...\"

hvor resten af DDL-statementet kommer i stedet for ...

The SQL statament from 20:16.12 was created by SQL Server so there is nothing wrong with this syntax! he only thing I can see is a benny.t mentiones and that is if your table name contains invalid characters.
If the SQL I gave 21:44.12 works then YOU have a synax problem which you need to sort out.

Det vil formodentlig også være en fordel at have feltnavnet ID omkranset af []

Det virker - It works
TAk og Thanx for your help