Oprettet tabel i Access via. asp ...

ret gæt  ...  value =\"test\"

:)

myConn.Execute(\"CREATE TABLE test4 (id Autoincrement PRIMARY KEY, design TINYINT, navigation INTEGER, hastighed INTEGER, rating INTEGER, dato DATETIME)\")


Hvor vil du sætte det? :-)

First, if you palce your question under Access then you may get more responce!

I am not sure that you can create default values using SQL. You should be able to use ADO to do it, but as I am no expert in ADO then I am not at all sure of which collection and methods to use.
In DAO its something like

Dim dbs as database
Dim tdf as TableDef
Dim fldName as field

Set db = OpenDatabase .....
set tdf = dbs.CreateTableDef....
set fldname = tdf.createField(\"Name\", dbText)
With fldname
  .required = True
  .Size = 40
  .AllowZeroLength = True
  .DefaultValue = \"Unknown\"
End with

tdf.fields.append fldName
dbs.Tabledefs.append tdf


or something like that, it may give you some ideas ....

Hey ...

Uhmmm .... It not give me what i neeed ... i need to set are default values in sql/access with asp ....

funi> in your CREATE TABLE you can as far as I know, ONLY sepecify the name and type of your fields, as you write yourself. So I think you will have to do it something like I do but in ADO!

Yes I can see what you want funi, but these properties arent (as far as I know) NOT accessible using SQL statements. In your ASP you are using ADO, myConn.Execute .... is committing an SQL statement to the access database, and as I have said you can only (as far as I know) specify the name and type for the fields.

So you will have to do it another way using ADO. But I cant help you there.

Okay ...

How do are set the default values.... it are the only i want! :o)

funi> Jeg prøver på dansk!

Med SQL kan man KUNNE angiv, navn og felt type. Hvis du vil opret tabeller og angiv en standardværdi for felterne skal du gøre det med ADO, i stil med det jeg har viste (med DAO).
Jeg kender ikke ADO godt nok, derfor kan jeg ikke hjælpe dig med det, sorry!

Terry ...

Det vil jeg så prøve .....

damm det er letter på en sql server ... hehe, så lige hvordan det skulle laves ...

Takker for hjælpen :)