CreateDatabase Method

       

Creates a new Database object, saves the database to disk, and returns an opened Database object (Microsoft Jet workspaces only).

Syntax

Set database = workspace.CreateDatabase (name, locale, options)

The CreateDatabase method syntax has these parts.

Part

Description

database

An object variable that represents the Database object you want to create.

workspace

An object variable that represents the existing Workspace object that will contain the database. If you omit workspace, CreateDatabase uses the default Workspace.

name

A String up to 255 characters long that is the name of the database file that you're creating. It can be the full path and file name, such as "C:\db1.mdb". If you don't supply a file name extension, .mdb is appended. If your network supports it, you can also specify a network path, such as "\\server1\share1\dir1\db1". You can only create .mdb database files with this method.

locale

A string expression that specifies a collating order for creating the database, as specified in Settings. You must supply this argument or an error occurs.


You can also create a password for the new Database object by concatenating the password string (starting with ";pwd=") with a constant in the locale argument, like this:


dbLangSpanish & ";pwd=NewPassword"


Note   Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.


If you want to use the default locale, but specify a password, simply enter a password string for the locale argument:


";pwd=NewPassword"


Note   Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

options

Optional. A constant or combination of constants that indicates one or more options, as specified in Settings. You can combine options by summing the corresponding constants.

 

Settings

You can use one of the following constants for the locale argument to specify the CollatingOrder property of text for string comparisons.

Constant

Collating order

dbLangGeneral

English, German, French, Portuguese, Italian, and Modern Spanish

dbLangArabic

Arabic

dbLangChineseSimplified

Simplified Chinese

dbLangChineseTraditional

Traditional Chinese

dbLangCyrillic

Russian

dbLangCzech

Czech

dbLangDutch

Dutch

dbLangGreek

Greek

dbLangHebrew

Hebrew

dbLangHungarian

Hungarian

dbLangIcelandic

Icelandic

dbLangJapanese

Japanese

dbLangKorean

Korean

dbLangNordic

Nordic languages (Microsoft Jet database engine version 1.0 only)

dbLangNorwDan

Norwegian and Danish

dbLangPolish

Polish

dbLangSlovenian

Slovenian

dbLangSpanish

Traditional Spanish

dbLangSwedFin

Swedish and Finnish

dbLangThai

Thai

dbLangTurkish

Turkish


 

You can use one or more of the following constants in the options argument to specify which version the data format should have and whether or not to encrypt the database.

Constant

Description

dbEncrypt

Creates an encrypted database.

dbVersion10

Creates a database that uses the Microsoft Jet database engine version 1.0 file format.

dbVersion11

Creates a database that uses the Microsoft Jet database engine version 1.1 file format.

dbVersion20

Creates a database that uses the Microsoft Jet database engine version 2.0 file format.

dbVersion30

(Default) Creates a database that uses the Microsoft Jet database engine version 3.0 file format (compatible with version 3.5).

 

If you omit the encryption constant, CreateDatabase creates an un-encrypted database. You can specify only one version constant. If you omit a version constant, CreateDatabase creates a database that uses the Microsoft Jet database engine version 3.0 file format.

Remarks

Use the CreateDatabase method to create and open a new, empty database, and return the Database object. You must complete its structure and content by using additional DAO objects. If you want to make a partial or complete copy of an existing database, you can use the CompactDatabase method to make a copy that you can customize.