-
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
-
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
-
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
-
Did you add a reference to Microsoft ADO Ext. 2.x for DDL and Security ??