| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
