"CREATE DATABASE" withOUT ADOX (SQL)

[Enigmachrysalis]

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.

 

[Norie]

This is probably a stupid question but why don't you want to use ADO(X) or other methods?

I've used DAO/ADO/Oracle/MySQL, probably a few other database technologies, programming languages etc

I've never heard of anything that would create tables/whatever without using some sort of code involving that sort of thing.

And I also think that you might be taking the wrong route - take advantage of the in-built functionality that's available.

Don't try and re-invent the wheel.

 

[Enigmachrysalis]

This reminds me of an earlier time. . .

No. I want to create tables on the fly and it would be nice if I could just execute a quick three word SQL statement instead of ADOX method. Don't reinvent the wheel on my account though.

 

[Norie]

You can create tables using SQL but it wouldn't be a simple 3 word statement.

Here's an example:

CREATE TABLE Top500Imported (F1 VARCHAR(50), F2 VARCHAR(50), F3 VARCHAR(50), F4 VARCHAR(50), F5 VARCHAR(50), F6 VARCHAR(50), F7 VARCHAR(50), F8 INT, F9 INT);

To use this you would create a new query, don't add any tables/fields to it.

Then in design view goto View>SQL, paste the above into the SQL window and then hit Run (!).

Is that what you are looking for?

 

[Enigmachrysalis]

No, that quote I re-posted was in response to the question before it earlier in the post that I thought you must not have seen.

I know how to create the tables with SQL, but I wondered if there was a way to do the same with the CREATE DATABASE stmt.

 

[Norie]

Sorry I'm confused, and I apologise for not reading the previous posts.

There is a CREATE DATABASE as you seem to know but I think that's all it does - create the database.

You then need to use CREATE TABLE with the database you've created to create the tables.

There is no one-liner for creating a database and tables in the database in one go.

You could probably use some sort of stored procedure, but that wouldn't be one-line either.