I'm having a little trouble with what I thought would be an easy task. I want to create a database with a two-word name. But my Execute command is failing even though I've tried many syntax combinations of ', '', (),[], etc to enclose a two-word name.
For example, I can do this:
SQL = "CREATE DATABASE oneword"
MyConnection.Execute SQL
But my Execute command fails with any one of these:
SQL = "CREATE DATABASE two words"
SQL = "CREATE DATABASE (two words)"
SQL = "CREATE DATABASE [two words]"
SQL = "CREATE DATABASE 'two words'"
Can someone please help me with the syntax?
Thanks in advance - Ron
For example, I can do this:
SQL = "CREATE DATABASE oneword"
MyConnection.Execute SQL
But my Execute command fails with any one of these:
SQL = "CREATE DATABASE two words"
SQL = "CREATE DATABASE (two words)"
SQL = "CREATE DATABASE [two words]"
SQL = "CREATE DATABASE 'two words'"
Can someone please help me with the syntax?
Thanks in advance - Ron