| | |
| |
Active Server Pages ASP control controls class classes module script Scripts applet CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Creating tables in Access |
|
From: |
Greg Baugher |
|
Date: |
1/22/1999 11:01:24 PM |
|
IP: |
207.208.34.148 |
I am trying to create a table in Access and I am using the following syntax:
Dim UserID, objConn, objRec
UserID = Session("UserID")
Set objConn = Server.CreateObject ("ADODB.Connection")
Set objRec = Server.CreateObject ("ADODB.Recordset")
objConn.Open "DSN=Guest"
objConn.Execute "Create Table " & UserID & " (GuestType text (15) Null,
GuestTitle text (10) Null, GuestFirst text (20) null)"
This works great, but when I try to create any other type of field
(AutoNumber, Number, Yes/No, Currency, Memo, etc.) I get a syntax error.
For AutoNumber, I have tried AutoNumber and Auto. Does anyone know the
syntax for this?
Thanks in Advance,
Greg Baugher
|
Follow Up - Re: Creating tables in Access - Harlan 1/25/1999 9:55:53 AM
|
|
|
|
|
|
