Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to open a .mdb with a password in OpenOffice Base. I can connect to the .mdb, but I cannot specify a password (forums say this method doesn't support passwords). Is there a way I can open this file using Base?

share|improve this question
up vote 2 down vote accepted

This topic is opened since 2009 and nobody has answered well. With OpenOffice 4.0.1 it is simple. Everybody is trying open directly the access database using the Connect to an existing database and selecting Microsoft access connexion, and this option fails in case the database is protected by password. In case you are finding this problem try this one:

  1. Connect to an existing database
  2. Select ODBC
  3. Click on explore and select the data source name is pointing to your databes. In case you have not created the data source name we are going to create it now.
  4. Click on Manage or Create (it depends of your language).
  5. Click on Add.
  6. Select Microsoft Access driver (*.mdb)
  7. write a name for the new data source name.
  8. click on Select in the data base and select your database.
  9. Once you have selected the database and before to accept you must click on Advanced.
  10. write here the password and accept everything
  11. Select the data source name created
  12. accept everything and finish

I have followed all these steps and it worked. Hope can help you too.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .