|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
