Re: Python library/module for MSAccess

2005-08-27 Thread Christos Georgiou
On Sat, 27 Aug 2005 04:45:25 GMT, rumours say that Stephen Prinster
[EMAIL PROTECTED] might have written:

Jonathon Blake wrote:

 [ Editing/creating msaccess databases on a Linux Box, and WINE _not_ 
 installed.]

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.

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
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python library/module for MSAccess

2005-08-27 Thread Alessandro Bottoni
Christos Georgiou wrote:
 I think the OP wants to *use* .mdb files on a linux system without using
 any msjet*.dll libraries.

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
-- 
http://mail.python.org/mailman/listinfo/python-list


Python library/module for MSAccess

2005-08-26 Thread 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?
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python library/module for MSAccess

2005-08-26 Thread Scott David Daniels
Jonathon Blake wrote:
 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.]

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
[EMAIL PROTECTED]
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python library/module for MSAccess

2005-08-26 Thread Jonathon Blake
Scott wrote:

 the Jet Database engine.  Easiest access for me is through the win32 module 
 'odbc'.

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?
-- 
http://mail.python.org/mailman/listinfo/python-list


Re: Python library/module for MSAccess

2005-08-26 Thread Stephen Prinster
Jonathon Blake wrote:

 [ Editing/creating msaccess databases on a Linux Box, and WINE _not_ 
 installed.]

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.
-- 
http://mail.python.org/mailman/listinfo/python-list