Python library/module for MSAccess

[Jonathon Blake]

All:

I thought I had seen a python library/module that easily enabled one
to read / write / create MSAccess databases a couple of years ago.
[My impression is that the Jet Database engine was _not_ required.]

Now, I can't find it, or any reference to such a library or module.
[I used google, and the module search tools on python.

Can somebody point me to an MSAccess library/module that does that?

xan

jonathon
--
Does your Office Suite conform to ISO Standards?

[Scott David Daniels]

Re: Python library/module for MSAccess

Jonathon Blake wrote:[color=blue]
> I thought I had seen a python library/module that easily enabled one
> to read / write / create MSAccess databases a couple of years ago.
> [My impression is that the Jet Database engine was _not_ required.][/color]

Access is a generalized I/O to databases. THe normal default DB _is_
the Jet Database engine. Easiest access for me is through the
win32 module 'odbc'.

--Scott David Daniels
Scott.Daniels@A cm.Org

[Jonathon Blake]

Re: Python library/module for MSAccess

Scott wrote:
[color=blue]
> the Jet Database engine. Easiest access for me is through the win32 module 'odbc'.[/color]

Thanks

That is going to make my job a lot rougher than I expected.
[ Editing/creating msaccess databases on a Linux Box, and WINE _not_ installed.]

xan

jonathon
--
Does your Office Suite conform to ISO Standards?

[Stephen Prinster]

Re: Python library/module for MSAccess

Jonathon Blake wrote:
[color=blue]
> [ Editing/creating msaccess databases on a Linux Box, and WINE _not_ installed.][/color]

I'm pretty sure I don't understand what you are wanting to do. You say
you have "msaccess databases on a Linux Box" and you are not using the
Jet Database engine. As far as I know, MS Access is just a front-end to
databases, with Jet as the default backend (though it can connect to
many others). What backend database engine/storage format are you
using? There might be a python library for connecting to it, bypassing
Access altogether.

[Christos Georgiou]

Re: Python library/module for MSAccess

On Sat, 27 Aug 2005 04:45:25 GMT, rumours say that Stephen Prinster
<prinster@mail. com> might have written:
[color=blue]
>Jonathon Blake wrote:
>[color=green]
>> [ Editing/creating msaccess databases on a Linux Box, and WINE _not_ installed.][/color]
>
>I'm pretty sure I don't understand what you are wanting to do. You say
>you have "msaccess databases on a Linux Box" and you are not using the
>Jet Database engine. As far as I know, MS Access is just a front-end to
>databases, with Jet as the default backend (though it can connect to
>many others). What backend database engine/storage format are you
>using? There might be a python library for connecting to it, bypassing
>Access altogether.[/color]

I think the OP wants to *use* .mdb files on a linux system without using
any msjet*.dll libraries.

There is a (C language) project that can read .mdb databases-- it can't
write them yet.[1]


[1] http://mdbtools.sourceforge.net/
--
TZOTZIOY, I speak England very best.
"Dear Paul,
please stop spamming us."
The Corinthians

[Alessandro Bottoni]

Re: Python library/module for MSAccess

Christos Georgiou wrote:[color=blue]
> I think the OP wants to *use* .mdb files on a linux system without using
> any msjet*.dll libraries.[/color]

Looks like you need a .mdb driver for the Python DB-API. Have a look here:

http://www.python.org/topics/database/

http://www.mayukhbose.com/python/ado/ado-connection.php (ADO)
http://www.vex.net/parnassus/ (Python Vaults of Parnassus)

Have a look at Kexi, as well (KDE based, no Python involved):

http://www.koffice.org/kexi/

http://www.kexi-project.org/

HTH

-----------------------------------
Alessandro Bottoni

[Dennis Lee Bieber]

Re: Python library/module for MSAccess

On Sat, 27 Aug 2005 04:45:25 GMT, Stephen Prinster <prinster@mail. com>
declaimed the following in comp.lang.pytho n:
[color=blue]
> Jonathon Blake wrote:
>[color=green]
> > [ Editing/creating msaccess databases on a Linux Box, and WINE _not_ installed.][/color]
>
> I'm pretty sure I don't understand what you are wanting to do. You say
> you have "msaccess databases on a Linux Box" and you are not using the
> Jet Database engine. As far as I know, MS Access is just a front-end to
> databases, with Jet as the default backend (though it can connect to
> many others). What backend database engine/storage format are you
> using? There might be a python library for connecting to it, bypassing
> Access altogether.[/color]

Aye... Access is really just a GUI for report/form design. ".mdb"
files are storage for three (four) things: Access reports, forms, (VBA
code modules), and JET relations (tables). Access "data projects" are
basically the first three hooked to SQL Server (and maybe other) data
storage.

The common engine is JET.
--[color=blue]
> =============== =============== =============== =============== == <
> wlfraed@ix.netc om.com | Wulfraed Dennis Lee Bieber KD6MOG <
> wulfraed@dm.net | Bestiaria Support Staff <
> =============== =============== =============== =============== == <
> Home Page: <http://www.dm.net/~wulfraed/> <
> Overflow Page: <http://wlfraed.home.ne tcom.com/> <[/color]