Utilize Plesk to connect external Microsoft Access databases to your applications effortlessly through an ODBC connection.
To connect a Microsoft Access Database (MDB) to Plesk, follow these steps:
-
Log in to your Plesk account.
-
Navigate to Websites & Domains and click on ODBC Data Sources.
-
Select Add ODBC DSN.
-
Input the Connection name (limited to letters and numbers; no spaces or symbols allowed). Optionally, add a description in the Connection Description field. CFrom the Driver dropdown menu, select "Microsoft Access Driver (*.mdb)". Once configured, click OK.
-
Provide the database path in the Database file path. If your database is password-protected, enter the Login ID and Password as required.
Note: It's advisable to retain the default values for other fields unless you comprehend their functionalities.
-
Scroll to the bottom and click Test Connection to verify the connection's functionality. Upon success, a confirmation message will appear. Click Finish to save the settings and complete the procedure.
