Differences between revisions 2 and 13 (spanning 11 versions)
Revision 2 as of 2013-08-04 03:14:16
Size: 1140
Editor: jiangwen365
Comment:
Revision 13 as of 2013-08-04 03:57:27
Size: 929
Editor: jiangwen365
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
= Microsoft Access =

= Microsoft Access mdb and accdb Database =
Line 11: Line 9:

* Widely used database by end users.
 * Widely used by end users.
Line 14: Line 11:
Line 16: Line 12:
Line 24: Line 19:
=== pypyodbc (Pure Python) === === PyPyODBC (Pure Python) ===
Line 34: Line 29:
On Windows Platform, PyPyODBC provide a set of methods to bring [[https://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file | PyPyODBC's extra support for Access on Windows Platform]] PyPyODBC is a pure Python script module providing ODBC interfacing functions, it runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit.
Line 36: Line 31:

PyPyODBC is a pure Python script, it runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit.


Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ).

Simple - the whole module is implemented in a single python script with less than 3000 lines.

Built-in Access MDB file creation and compression functions on Windows.
However, '''''on Windows Platform''''', PyPyODBC provides a set of methods bringing [[https://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file | PyPyODBC's extra support for Access on Windows Platform]]

Microsoft Access mdb and accdb Database

URL

http://office.microsoft.com/en-us/access/‎

Licence
Commercial/Proprietary software
Platforms
Windows

Pros

  • Widely used by end users.
  • It comes with the GUI tools,and very user friendly.

Cons

  • Windows only.


DB API 2.0 Drivers

PyPyODBC (Pure Python)

URL

http://code.google.com/p/pypyodbc

License
MIT
Platforms
Windows, Linux
Python versions
2.4 - 3.3

PyPyODBC is a pure Python script module providing ODBC interfacing functions, it runs on CPython / IronPython / PyPy , Version 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit.

However, on Windows Platform, PyPyODBC provides a set of methods bringing PyPyODBC's extra support for Access on Windows Platform

Microsoft Access (last edited 2014-06-07 10:50:56 by MarcAndreLemburg)

Unable to edit the page? See the FrontPage for instructions.