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