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

June 17, 2024 / Plesk

In this tutorial, you will learn how Plesk allows you to connect external Microsoft Access databases to your applications using an ODBC connection.

Let us follow the steps-

  1. Log in to Plesk.
  2. Go to “Websites & Domains”.
    Websites & Domains
  3. Click on “ODBC Data Sources.”
    ODBC Data Sources
  4. Click “Add ODBC DSN.”
    Add ODBC DSN
  5. Configure Connection-
    1. Enter a connection name (letters and numbers only).
    2. Optionally, add a description.
    3. Select “Microsoft Access Driver (*.mdb)” from the Driver dropdown.
    4. Click “OK.”
      Driver
  6. Database Details-
    1. Enter the database file path.
    2. Provide the Login ID and Password if needed.
    3. Keep default values for other fields unless necessary.
      set up odbc connection
  7. Test and Save-
    1. Scroll down and click “Test Connection.”
    2. Upon success, click “Finish” to save the settings.
      Test Connection

This way you can connect a Microsoft Access Database (MDB) in Windows Plesk.

For additional enhancements, you can subscribe to the Microsoft Access database in Plesk for Windows. This further procedure ensures that your database resources are fully utilised and integrated into the Plesk environment. Using Plesk’s user-friendly interface, this method ensures you keep updated and effectively manage your database subscriptions.

Dominos Search