Creating tables in Access 2000 using SQL (VB6)

[gwar2k1]

Is this possible as you cant do it in Access itself? I know how to make my database perfectly using SQL so this would be a big bonus if I could do it this way.

If it is possible im unclear on how I would do things involving the connection and recordset. Currently I use the typical connections when creating a new table

Dim catDB As ADOX.Catalog
Dim newTBL As ADOX.Table
Set catDB = New ADOX.Catalog
catDB.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & flPath & mdb
Set newTBL = New ADOX.Table

I looked at the options on newTBL. but none stood out to me as saying "i accept sql right here" such as the RecdSet.open feature. So is it even possible?

TIA

~*Gwar3k1*~
"To the pressure, everything's just like: an illusion. I'll be losing you before long..."