In this case we will assume you need a table that has four fields that will house the data from a form. This form will extract a name, email address, comments, and geographical region from users on your site. 

First lets start with a connection. I use a DSN-LESS connection here, but it's up to you.

<%
Set adConn = Server.CreateObject("ADODB.Connection")
adPath = "E:/the/path/to/your/database.mdb"
adConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & adPath & ";"
%>


Next comes the SQL work. Here's where we actually do the work.

<%
adSQL = "CREATE TABLE newtbl (Name text (50), Email text (75), Comments text (255), Region text (50))"
%>

And we execute the SQL statement now.

<%
adConn.Execute adSQL
%>

Of course we close everything.

<%
adConn.Close
Set adConn = Nothing
%>

Altogether:
<% 
Set adConn = Server.CreateObject("ADODB.Connection")
adPath = "E:/the/path/to/your/database.mdb"
adConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & adPath & ";"
adSQL = "CREATE TABLE newtbl (Name text (50), Email text (75), Comments text (255), Region text (50))"
adConn.Execute adSQL
adConn.Close
Set adConn = Nothing
%>