create database with sql

[joemeshuggah]

i recently purchased "sql demystified" to start familiarizing myself with
sql... www.osborne.com has a sample database available for download for use
with the book, however it is simply a text file with all of the sql to create
the database. how do you go about running the script in access to create the
database? also, would it be different for access 2000 and 2003 (i would like
to create the sample database on both versions).

 

[mray29]

I believe your script is to create a SQL server database, not an Access
database. You have to have some version of SQL Server installed on your
system to create the database. You can get a free version of SQL Server
Express from Microsoft, or you can by the developer version for about $50.

 

[Allen Browne]

The code to create a new database in Access is like this:
http://allenbrowne.com/func-DAO.html#CreateDatabaseDAO

Once you have the new database, you can use a DDL query to CREATE TABLE:
http://allenbrowne.com/func-DDL.html#CreateTableDDL