| <!DOCTYPE html> |
| <html> |
| <head> |
| <title>HOW-TO use Microsoft Access databases from within OpenOffice.org 1.1</title> |
| <meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8"> |
| </head> |
| <body> |
| <h1>HOW-TO use Microsoft Access databases from within |
| OpenOffice.org 1.1</h1> |
| |
| <table border="1" width="100%" cellspacing="0" cellpadding="2" bordercolor="#99ccff" bgcolor="#FFFFFF"> |
| <td bgcolor="#f0f0f0"> |
| These faq have been compiled over the span of OpenOffice's lifetime. |
| Most of the information is now out of date. |
| See <a href="https://wiki.openoffice.org/wiki/Documentation/FAQ">the OpenOffice FAQ page</a> on our official wiki |
| for up-to-date information. |
| If you find instances that need updating, let us know by sending a note to <a href="mailto:dev@openoffice.apache.org">dev@openoffice.apache.org</a>. |
| </td> |
| </table> |
| |
| <p>OpenOffice.org (OOo) is able to read and write from a |
| wide variety of databases, as long as they support one of |
| the standard interface specifications such as ODBC or JDBC. |
| Fortunately, Microsoft Access (MS-Access) supports ODBC. |
| This HOW-TO takes you step by step through the process of |
| linking OOo to MS-Access using ODBC.</p> |
| <p>The process has three simple steps:</p> |
| <ol> |
| <li> |
| <p>Create an <em>ODBC Data Source</em> for each database |
| you want to use (you only need to do this once per |
| database)</p> |
| </li> |
| <li> |
| <p>Create an <em>ODBC Data Source</em> within |
| OpenOffice.org for each database (you only need to do this |
| once)</p> |
| </li> |
| <li> |
| <p>Enjoy using your MS-Access databases in OOo!</p> |
| </li> |
| </ol> |
| <p><i>Note: if you can't read a screenshot, click on it to open a larger |
| version in a new browser window</i></p> |
| <h2>Creating an ODBC Data Source for the MS-Access |
| database</h2> |
| <p>Within MS-Windows, choose <em>Start -> Settings -> |
| Control Panel</em> and double-click the <em>ODBC Data |
| Sources</em> icon</p> |
| <p><font color="#000000"><a href="ms-access_html_m7615b54d.png" target="_new"> |
| <img src="ms-access_html_m7615b54d.png" name="Graphic1" align="left" |
| width="67" height="65" border="1" alt="image" id= |
| "Graphic1" /></a><br clear="left" /></font></p> |
| <p>to run the <em>ODBC Data Source Administrator:</em></p> |
| <p><a href="ms-access_html_m101014de.png" target="_new"> |
| <img src="ms-access_html_m101014de.png" name="Graphic2" |
| align="left" width="366" height="296" border="0" alt= |
| "image" id="Graphic2" /></a></p> |
| <br clear="left" /> |
| <p style="margin-bottom: 0cm; page-break-before: always"> |
| Click on the <strong>Add</strong> button to display the |
| <em>Create New Data Source</em> dialogue box:</p> |
| <p><a href="ms-access_html_m33b74a80.png" target="_new"> |
| <img src="ms-access_html_m33b74a80.png" name="Graphic3" |
| align="left" width="408" height="323" border="0" alt= |
| "image" id="Graphic3" /></a></p> |
| <br clear="left" /> |
| <p>Select the <em>Microsoft Access Driver</em> and press |
| the <strong>Finish</strong> button. This will display the |
| <em>ODBC Microsoft Access Setup</em> dialogue box:</p> |
| <p><a href="ms-access_html_44241aca.png" target="_new"> |
| <img src="ms-access_html_44241aca.png" name="Graphic4" |
| align="left" width="405" height="304" border="0" alt= |
| "image" id="Graphic4" /></a></p> |
| <br clear="left" /> |
| <p>Give the new data source a name (e.g. the same name as |
| your MS-Access database) and a description. Use the |
| <strong>Select</strong> button to select your MS-Access |
| database file (*.dbf) and press <strong>OK</strong>.</p> |
| <p style="margin-bottom: 0cm; page-break-before: always"> |
| You should now see the ODBC Data Source you have created |
| listed in the <em>ODBC Data Source Administrator</em>:</p> |
| <p><a href="ms-access_html_m32c4755d.png" target="_new"> |
| <img src="ms-access_html_m32c4755d.png" name="Graphic5" |
| align="left" width="367" height="299" border="0" alt= |
| "image" id="Graphic5" /></a></p> |
| <br clear="left" /> |
| <p>Click <strong>OK</strong> to close the Administrator. |
| Note that every database you want to use in OOo will need |
| to have its own ODBC Data Source defined here.</p> |
| <h2>Creating a Data Source within OOo</h2> |
| <p>From within an OOo application, select Tools -> Data |
| Sources... You will notice that OOo comes with one |
| pre-installed Data Source called <em>Bibliography</em>. |
| Ignore this, and press the <em>New Data Source</em> |
| button</p> |
| <p><a href="ms-access_html_2316788d.png" target="_new"> |
| <img src="ms-access_html_2316788d.png" name="Graphic6" |
| align="left" width="569" height="330" border="0" alt= |
| "image" id="Graphic6" /></a></p> |
| <br clear="left" /> |
| <p>Select <span style="font-style: normal">Database |
| Type</span> <em>ODBC</em>, and press the select button |
| <strong>[...]</strong> and choose the ODBC Data Source you |
| have just created. Give it a name, press the |
| <strong>Apply</strong> button, and press |
| <strong>OK</strong> to close the Data Source Administration |
| tool.</p> |
| <h2>Using the Data Source within OOo</h2> |
| <p>There are other FAQs which describe using the database |
| features within OOo. However, as a quick preview, select |
| <em>View -> Data Sources</em> (or press |
| <strong>F4</strong>). You are now ready to use your |
| MS-Access database within OOo applications:</p> |
| <p><a href="ms-access_html_2594102a.png" target="_new"> |
| <img src="ms-access_html_2594102a.png" name="Graphic7" |
| align="left" width="642" height="482" border="0" alt= |
| "image" id="Graphic7" /></a></p> |
| <br clear="left" /> |
| </body> |
| </html> |
| |