Creating database with ADO / debugging SQL

[cyoconnor]

Try as I might, I can't figure out how to create
a (Jet/Access) database using ADO.
There's no createdatabase I recall from DAO, and
I can't see how to send an SQL instruction without an existing database. (for this particular problem,
I need to automatically create a new db twice a day)
I feel like I'm something obvious here.

One more questions:

In VB6, how do I debug SQL statements? There seems to be a whole menu called Query in the IDE, but it's always grayed out. I never know why my SQL won't work.


Thanks in advance for your assistance. I am aware that many members here are donating significant amounts of their time and expertise to people like me.

CYOCONNOR

[Clunietp]

Create DB using ADO:

http://www.vb-world.net/forums/showt...threadid=11249

Debug SQL in VB:

You need to add a data link to your data link window, then open your table/query from there. You should then have all of your database/query options available.

HTH

Tom

[cyoconnor]

Tom, I found that post, but my machine refused to recognise the ADOX.catalog as a valid type

CYOCONNOR

Edited by cyoconnor on 03-12-2000 at 12:20 PM

[Clunietp]

Did you add a reference to Microsoft ADO Ext. 2.x for DDL and Security ??