Hello everyone,

I seem to be having the following problem. I run this code below but no 
matter what, I keep getting "page can not be displayed, internet server 
error".

Is there something simple im missing?

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_al_STRING
Command1.CommandText = "CREATE TABLE bandits(id autoincrement, name text, 
age byte);"
Command1.CommandType = 4
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

Thanks!

Hi

Looks alright, might be a permissions thing.  To find out exactly what your
error is turn off friendly errors in IE (tools--> internet options -->
advanced --> scroll down and untick show friendly http error messages.

Cheers
Darrell

-----Original Message-----
From: saslaw@c... [mailto:saslaw@c...]
Sent: 03 October 2002 21:09
To: Access ASP
Subject: [access_asp] Help with Creating tables in access through ASP.


Hello everyone,

I seem to be having the following problem. I run this code below but no
matter what, I keep getting "page can not be displayed, internet server
error".

Is there something simple im missing?

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_al_STRING
Command1.CommandText = "CREATE TABLE bandits(id autoincrement, name text,
age byte);"
Command1.CommandType = 4
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

Thanks!