, MS Access. MS ADO (. 34.4).
ADOConnection
. ADOConnection ADO . , ConnectionString. ConnectionString (. 34.5).
34.5 ―
1. (Use Data Link File);
2. (Use Connection String).
. Build (. 34.6).
34.6 ―
Provider ADO . - , Microsoft OLE DB Provider for ODBC Drivers. ODBC , (, ).
MS Access Microsoft Jet OLE DB Provider. MS Office, Windows , : Microsoft Jet 4.0 OLE DB Provider. Next, Connection (. 34.7).
, ( ) Select or enter a database name. , , .
34.7 ― Connection
.
:
1. (User name), , MS Access;
2. (Password) , ;
3. (Blank password) , ;
4. (Allow saving password). , .
, Test Connection, . , Test connection succeeded. , , , (, 34.5).
ADOConnection LoginPrompt, False. , . Connected True, .
|
|
. . ADOTable ADO . Name BookName.
TADOTable
ConnectionString . ? , ADOConnection. BookName Connection, . ٸ Connection ADOConnection1. ConnectionString.
TableName ( ). , , . Active true.
TDataSource
DataSource Data Access . , . DataSet BookTable.
TDBGrid
, . ― TDBGrid. -, . , .
34.8 ―
. DataSuorce TDBGrid DataSource1.
:
Delphi, MS Access 2003, :
:
;
;
;
;
.
:
;
.
;
;
;
.
:
1. Data Access, , .
2. Data ontrols, , .
3. BDE, , .
Data Access, Data ontrols BDE, , .