How to Connect a Microsoft Access Database(MDB) in Windows Plesk?

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:

  1. Log in to your Plesk account.

  2. Navigate to Websites & Domains and click on ODBC Data Sources.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/03/odbc_ds.png

  1. Select Add ODBC DSN.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/03/add_dsn.png

  1. 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.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/03/create_conn.png

  1. Provide the database path in the Database file path. If your database is password-protected, enter the Login ID and Password as required.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/03/setup_conn.png

Note: It's advisable to retain the default values for other fields unless you comprehend their functionalities.

  1. 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.

https://www.milesweb.in/hosting-faqs/wp-content/uploads/2021/03/test_next.png

 


Was this article helpful?

mood_bad Dislike 0
mood Like 0
visibility Views: 16347