What is the procedure to connect Delphi application to MS access database?

What is the procedure to connect Delphi application to MS access database?

- The procedure to connect Delphi application to MS access database is as follows:

- Open ODBC data sources and add a new data source with the definition of ACCESS DATA.

- Insert a unique Data Source Name and select the database file that needs to be used.

- Select the database source and open the Database engine configuration to set BDE configuration screen.

- Choose NEW ODBC driver and provide the SQL link driver information.

- The default ACCESS DATA will be chosen and the new Default data source name will be selected.

- Create a Tdatabase component and set the AliasName with the name that is being defined.

- Create a database and set the LoginPrompt to FALSE. Also, add TQuery component and set the DatabaseName to any name that is being provided.

- Add the TDataSource component and set the DataSet as per the TQuery component.