Adding New DSN for Microsoft Access Database

To create a DSN for Microsoft Access Database, follow these steps:

  1. Go to Websites select a required website and click More Tools
  2. Select DSN Management. This screen displays the existing DSNs.
  3. Click the Add New DSN button. The DSN creation Wizard starts.
  4. Specify the data source name and the description of DSN being created.
  5. If there is an existing database you will be suggested to select the Datasource. Select the Microsoft Access database radio button. Click Next to continue.
  6. In this step you need to specify DSN parameters:
    • Location of the database file.
    • Advanced DSN parameters.
      • Buffer size – The size of the internal buffer, in kilobytes, that is used by Microsoft Access to transfer data to and from the disk. Any integer value divisible by 256 can be used.
      • Read only – Designate the database as read-only. This safeguards the database from any updates.
      • Extended ANSI SQL – Enable new features available since Jet 4.0 that are not enabled by default.

        Jet 4.0 has several new features that are not enabled by default in the ODBC Desktop Database Drivers version 4.0. To take advantage of these new features, an application will have to set a new connection attribute, add a new attribute to the connection string, or set the attribute in a DSN. The attribute is called ExtendedAnsiSQL and pertains only to the Microsoft ODBC Desktop Database Drivers 4.0 and later.

      • User name – User ID name used for login name.
      • Password.
  7. Click Finish to complete the creation of DSN for Microsoft Access Database.