FireDAC.Phys.MSAcc.TFDMSAccessService.CreateDB
Delphi
procedure CreateDB;
C++
void __fastcall CreateDB(void);
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
procedure function |
public | FireDAC.Phys.MSAcc.pas FireDAC.Phys.MSAcc.hpp |
FireDAC.Phys.MSAcc | TFDMSAccessService |
Description
Creates a new Access database.
Use the CreateDB method to create a new empty database. To run CreateDB, an application must specify Database, that is the source database file name. You can optionally specify:
- The database format version (DBVersion).
- The password to protect the database (Password).
- Whether to encrypt the database (Encrypted).
- The default database sort order (SortOrder).
The file pointed by Database must not exist when CreateDB is called. If the operation fails, the Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed exception is raised.
Example 1
FDMSAccessService1.Database := 'c:\test.mdb'; FDMSAccessService1.DBVersion := avDefault; FDMSAccessService1.CreateDB;
Example 2
// Create encrypted database FDMSAccessService1.Database := 'c:\test.accdb'; FDMSAccessService1.DBVersion := avAccess2007; FDMSAccessService1.Encrypted := True; FDMSAccessService1.CreateDB;
Example 3
// Specify default sort order of database FDMSAccessService1.Database := 'c:\test.accdb'; FDMSAccessService1.DBVersion := avAccess2007; FDMSAccessService1.SortOrder := '0x00000409'; FDMSAccessService1.CreateDB;