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.