Enigmachrysalis
Active Member
- Joined
- Apr 13, 2009
- Messages
- 350
The following all is set to occur in Excel VBA (i.e. why it's not in Access forum)
I know of a way to create a database using a new ADOX catalog, BUT as there is a dedicated "CREATE DATABASE db_Name" SQL statement., I was wondering how you can execute a SQL statement (as you would to create a table) when there is no file to which you can connect yet.
I have searched for some manner of execute statement in ADOX, but all I can find is Create in the ADOX library.
P.S. I tried to connect to the prospective save folder location, but the error prompt indicates that the location is in use or it cannot be accessed.
I know of a way to create a database using a new ADOX catalog, BUT as there is a dedicated "CREATE DATABASE db_Name" SQL statement., I was wondering how you can execute a SQL statement (as you would to create a table) when there is no file to which you can connect yet.
I have searched for some manner of execute statement in ADOX, but all I can find is Create in the ADOX library.
P.S. I tried to connect to the prospective save folder location, but the error prompt indicates that the location is in use or it cannot be accessed.