https://neowiki.neooffice.org/index.php?title=Working_with_Microsoft_Access_databases&action=history&feed=atom
Working with Microsoft Access databases - Revision history
2024-03-28T21:30:30Z
Revision history for this page on the wiki
MediaWiki 1.10.1
https://neowiki.neooffice.org/index.php?title=Working_with_Microsoft_Access_databases&diff=16857&oldid=prev
Sardisson: bold the limitations sentence and reword the final clause
2013-03-17T18:58:58Z
<p>bold the limitations sentence and reword the final clause</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 18:58, 17 March 2013</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 1:</strong></td>
<td colspan="2" align="left"><strong>Line 1:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">Microsoft Access is a widely-used database on Windows. Like [[NeoBase|Base]], Access is capable of serving as a front-end to various databases and as a stand-alone database itself. As a result, Access files (<code>.mdb</code>) may be just a collection of forms, queries, and settings for connecting to an external database, or they may be forms, queries, and the actual data.</td><td> </td><td style="background: #eee; font-size: smaller;">Microsoft Access is a widely-used database on Windows. Like [[NeoBase|Base]], Access is capable of serving as a front-end to various databases and as a stand-alone database itself. As a result, Access files (<code>.mdb</code>) may be just a collection of forms, queries, and settings for connecting to an external database, or they may be forms, queries, and the actual data.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">Unfortunately, Access is one of the least interoperable of Microsoft's many applications. This means that there are a very limited number of options for reading Access databases on anything other than Microsoft Windows. Even solutions that are available are typically limited; for instance, many offer read-only connections to an Access database, and any forms <del style="color: red; font-weight: bold; text-decoration: none;">and </del>saved queries developed in Access <del style="color: red; font-weight: bold; text-decoration: none;">usually cannot be read or imported</del>.</td><td>+</td><td style="background: #cfc; font-size: smaller;">Unfortunately, Access is one of the least interoperable of Microsoft's many applications. This means that there are a very limited number of options for reading Access databases on anything other than Microsoft Windows. <ins style="color: red; font-weight: bold; text-decoration: none;">'''</ins>Even solutions that are available are typically limited; for instance, many offer read-only connections to an Access database, and <ins style="color: red; font-weight: bold; text-decoration: none;">it is unlikely that any solution will support reading or importing </ins>any forms <ins style="color: red; font-weight: bold; text-decoration: none;">or </ins>saved queries developed in Access.<ins style="color: red; font-weight: bold; text-decoration: none;">'''</ins></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">==Potential ways of extracting data from an Access <code>.mdb</code> file==</td><td> </td><td style="background: #eee; font-size: smaller;">==Potential ways of extracting data from an Access <code>.mdb</code> file==</td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Working_with_Microsoft_Access_databases&diff=16266&oldid=prev
Sardisson: /* Converting a Microsoft Access database to a format useable in NeoOffice */ add new commercial app
2011-02-24T03:07:09Z
<p><span class="autocomment">Converting a Microsoft Access database to a format useable in NeoOffice -</span> add new commercial app</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 03:07, 24 February 2011</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 19:</strong></td>
<td colspan="2" align="left"><strong>Line 19:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">===Converting a Microsoft Access database to a format useable in NeoOffice===</td><td> </td><td style="background: #eee; font-size: smaller;">===Converting a Microsoft Access database to a format useable in NeoOffice===</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">'''''N.B.''' To our knowledge, '''no one has tried''' any of the potential solutions below to verify that they work and produce output that can be used in NeoOffice.''</td><td> </td><td style="background: #eee; font-size: smaller;">'''''N.B.''' To our knowledge, '''no one has tried''' any of the potential solutions below to verify that they work and produce output that can be used in NeoOffice.''</td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">* [http://jabakobob.net/mdbviewer/ MDB Viewer for Mac] is a $5.99 application available in the [http://itunes.apple.com/app/mdb-viewer/id417392270?mt=12 App Store] that supports '''viewing''' Access '97, 2002 and 2003 databases (tables only; no forms, queries or reports). It can also export tables to CVS files or to MySQL or PostgreSQL SQL dumps.</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">*[http://forjamari.linex.org/projects/mdb2odb/ mdb2odb] is/was a Spanish project to develop an Access-to-OpenDocument Database converter. The project's binaries were available for Debian/Ubuntu, so it is unknown if the code compiles on Mac OS X (or if the project still exists, as its website is non-functional as of this writing).</td><td> </td><td style="background: #eee; font-size: smaller;">*[http://forjamari.linex.org/projects/mdb2odb/ mdb2odb] is/was a Spanish project to develop an Access-to-OpenDocument Database converter. The project's binaries were available for Debian/Ubuntu, so it is unknown if the code compiles on Mac OS X (or if the project still exists, as its website is non-functional as of this writing).</td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Working_with_Microsoft_Access_databases&diff=15560&oldid=prev
Sardisson: /* Related External Links */ this seems possibly useful; saw it today on MacInTouch
2009-10-27T03:49:55Z
<p><span class="autocomment">Related External Links -</span> this seems possibly useful; saw it today on MacInTouch</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 03:49, 27 October 2009</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 33:</strong></td>
<td colspan="2" align="left"><strong>Line 33:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* Other options and further discussion can be found on the Trinity forum: [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=30559#30559], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=51075#51075].</td><td> </td><td style="background: #eee; font-size: smaller;">* Other options and further discussion can be found on the Trinity forum: [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=30559#30559], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=51075#51075].</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td colspan="2"> </td><td>+</td><td style="background: #cfc; font-size: smaller;">* [http://www.fmpromigrator.com/services/access_to_fmpro_service.html Commercial service to convert Access databases to FileMaker Pro databases] (which NeoOffice can [[Configuring_FileMaker_Pro|connect to or possibly convert]])</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Utiliser les Bases de Données Microsoft Access|Français]]}}<!-- [[It:|Italiano]] [[Es:|Español]]}}--></td><td> </td><td style="background: #eee; font-size: smaller;">{{botlangbarEN|[[Fr:Utiliser les Bases de Données Microsoft Access|Français]]}}<!-- [[It:|Italiano]] [[Es:|Español]]}}--></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td><td> </td><td style="background: #eee; font-size: smaller;">[[Category:NeoOffice]][[Category:Tips and Hints]]</td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Working_with_Microsoft_Access_databases&diff=14964&oldid=prev
Sardisson: /* Converting a Microsoft Access database to a format useable in NeoOffice */ typo
2009-02-28T06:47:08Z
<p><span class="autocomment">Converting a Microsoft Access database to a format useable in NeoOffice -</span> typo</p>
<table border='0' width='98%' cellpadding='0' cellspacing='4' style="background-color: white;">
<tr>
<td colspan='2' width='50%' align='center' style="background-color: white;">←Older revision</td>
<td colspan='2' width='50%' align='center' style="background-color: white;">Revision as of 06:47, 28 February 2009</td>
</tr>
<tr><td colspan="2" align="left"><strong>Line 20:</strong></td>
<td colspan="2" align="left"><strong>Line 20:</strong></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">'''''N.B.''' To our knowledge, '''no one has tried''' any of the potential solutions below to verify that they work and produce output that can be used in NeoOffice.''</td><td> </td><td style="background: #eee; font-size: smaller;">'''''N.B.''' To our knowledge, '''no one has tried''' any of the potential solutions below to verify that they work and produce output that can be used in NeoOffice.''</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td>-</td><td style="background: #ffa; font-size: smaller;">*[http://forjamari.linex.org/projects/mdb2odb/ mdb2odb] is/was a Spanish project to develop an Access-to-OpenDocument Database converter. The project's binaries were available for Debian/Ubuntu, so it is unknown if the code compiles on Mac OS X (or if the project still exists, as its website <del style="color: red; font-weight: bold; text-decoration: none;">in </del>non-functional as of this writing).</td><td>+</td><td style="background: #cfc; font-size: smaller;">*[http://forjamari.linex.org/projects/mdb2odb/ mdb2odb] is/was a Spanish project to develop an Access-to-OpenDocument Database converter. The project's binaries were available for Debian/Ubuntu, so it is unknown if the code compiles on Mac OS X (or if the project still exists, as its website <ins style="color: red; font-weight: bold; text-decoration: none;">is </ins>non-functional as of this writing).</td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;"></td><td> </td><td style="background: #eee; font-size: smaller;"></td></tr>
<tr><td> </td><td style="background: #eee; font-size: smaller;">* If you have access to a Windows PC, there are additional options:</td><td> </td><td style="background: #eee; font-size: smaller;">* If you have access to a Windows PC, there are additional options:</td></tr>
</table>
Sardisson
https://neowiki.neooffice.org/index.php?title=Working_with_Microsoft_Access_databases&diff=14963&oldid=prev
Sardisson: move from the old misc db resources page and transform into more of a real article
2009-02-28T06:45:37Z
<p>move from the old misc db resources page and transform into more of a real article</p>
<p><b>New page</b></p><div>Microsoft Access is a widely-used database on Windows. Like [[NeoBase|Base]], Access is capable of serving as a front-end to various databases and as a stand-alone database itself. As a result, Access files (<code>.mdb</code>) may be just a collection of forms, queries, and settings for connecting to an external database, or they may be forms, queries, and the actual data.<br />
<br />
Unfortunately, Access is one of the least interoperable of Microsoft's many applications. This means that there are a very limited number of options for reading Access databases on anything other than Microsoft Windows. Even solutions that are available are typically limited; for instance, many offer read-only connections to an Access database, and any forms and saved queries developed in Access usually cannot be read or imported.<br />
<br />
==Potential ways of extracting data from an Access <code>.mdb</code> file==<br />
<br />
===Connecting to Microsoft Access databases from NeoOffice===<br />
<!-- this is Ed's quote; not sure of the context or if it is still relevant<br />
Well, a lack of drivers will definitely cause files to not be openable. Anything that requires the MS ODBC bridges won't work for sure, including Access files.<br />
--><br />
'''''N.B.''' To our knowledge, '''no one has tried''' any of the potential solutions below to verify that they work with NeoOffice.''<br />
<br />
*A Mac ODBC driver that works with MS Access files is the [http://www.actualtechnologies.com/product_access.php Actual] ODBC driver. It is a commercial one ($29), but it works with Access. (There was a [http://bugzilla.neooffice.org/bug.php?op=show&bugid=1535 report] that NeoOffice 2.0 Alpha worked with Actual's '''MySQL''' ODBC driver, but no one has tried the '''Access''' ODBC driver.)<br />
<br />
*[http://www.csv-jdbc.com/stels_mdb_jdbc.htm StelsMDB] is a commercial ($110; 30-day free trial) MDB JDBC type 4 driver that allows users to perform SQL queries and other JDBC operations on Microsoft Access database files (MS Access 2000, 2002, 2003, XP versions). Presumably NeoOffice could use the JDBC driver to connect to the Access database.<br />
<br />
*[http://www.hxtt.com/access.html HXTT Access Pure Java JDBC (1.2, 2.0, 3.0, 4.0) Drivers for MS Access] is a commercial ($300+; trial available) Type 4 JDBC driver that supports Access versions from 95, 97, 2000, XP, 2002, to 2003. Presumably NeoOffice could use the JDBC driver to connect to the Access database.<br />
<br />
===Converting a Microsoft Access database to a format useable in NeoOffice===<br />
'''''N.B.''' To our knowledge, '''no one has tried''' any of the potential solutions below to verify that they work and produce output that can be used in NeoOffice.''<br />
<br />
*[http://forjamari.linex.org/projects/mdb2odb/ mdb2odb] is/was a Spanish project to develop an Access-to-OpenDocument Database converter. The project's binaries were available for Debian/Ubuntu, so it is unknown if the code compiles on Mac OS X (or if the project still exists, as its website in non-functional as of this writing).<br />
<br />
* If you have access to a Windows PC, there are additional options:<br />
**The [http://www.mysql.com/products/tools/migration-toolkit/ MySQL Migration Toolkit] for the Mac can be found in the [http://dev.mysql.com/downloads/gui-tools/5.0.html MySQL GUI Tools Bundle] and should be able to be used to move data from an MS Access database to a MySQL one (which NeoOffice will happily deal with).<br>The Migration Toolkit is known to work with Access files on Windows; however, the migration process appears to require [http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-accessprep.html preliminary preparations] to be done in Access before the migration can begin.<br />
** Export the data from Access into an Excel file, which NeoOffice can open in Calc or [[Using a Calc spreadsheet as a data source|use as a data source]] for Base.<br />
** It may also be possible to install OpenOffice.org and use [http://wiki.services.openoffice.org/wiki/MSA-Base_Faq tools in Base and Windows] to load the data and transfer it to another format.<br />
<br />
==Related External Links==<br />
*[http://wiki.services.openoffice.org/wiki/MSA-Base_Faq OOo wiki article on the features available in OOoBase when connected to an Access database] (currently requires Windows)<br />
* [http://wiki.services.openoffice.org/wiki/Connecting_to_Microsoft_Access OOo wiki article on configuring OOoBase on Windows to connect to an Access database]<br />
<br />
* Other options and further discussion can be found on the Trinity forum: [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=23436#23436], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=30559#30559], [https://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=51075#51075].<br />
<br />
<br />
{{botlangbarEN|[[Fr:Utiliser les Bases de Données Microsoft Access|Français]]}}<!-- [[It:|Italiano]] [[Es:|Español]]}}--><br />
<br />
[[Category:NeoOffice]][[Category:Tips and Hints]]</div>
Sardisson