Building Universe on MS Access

Published on Author bloggerzeroLeave a comment

Steps to create a DSN for the MS Access Database:

From Start Menu->Control Panel -> Administrative Tools ->

  1. Data Sources (ODBC)
  2. System DSN tab
  3. Click on ADD
  4. Select Microsoft Access Driver (*.mdb), Click on Finish
  5. Give a Data Source Name : MyDSN
  6. Under the database section, click on Select
  7. Choose the .mdb file, click on OK

Login to Universe Designer

File-> Parameters -> Click on “New” to create connection

  1. Click on Next, provide a connection name
  2. Select the Microsoft -> MS Access 2003, ODBC Drivers, Click on Next.
  3. Select the DSN created above
  4. Click Next, Next, Finish.



Leave a Reply

Your email address will not be published. Required fields are marked *