|
|
|
|
|
| | |
| |
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: |
Re: create a table in access by asp |
|
From: |
Mike B |
|
Date: |
2/23/2000 11:24:55 AM |
|
IP: |
208.205.27.194 |
This worked for me
<html>
<head><title>Test</title></head>
<BODY>
<%
Set conn = Server.CreateObject("ADODB.Connection")
driv = "driver={Microsoft Access Driver (*.mdb)}"
conn.Open driv & ";dbq={database path/name goes here}"
conn.execute("CREATE TABLE YetAnotherThirdTable (FirstName TEXT, LastName TEXT, SSN BIT CONSTRAINT MyFieldConstraint PRIMARY KEY);")
set rs = nothing
conn.close
set conn = nothing
%>
</body>
</html>
Hope this helps
Mike
|
Previous Message
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
