Thanks Wade & all, It looks like the easiest way forward is to convert all the databases to mysql, front-end them for the users with Access, and use the mysqlda for the zope stuff. Only problem I'm having is getting the MySQL-python-0.9.0 setup.py file to work. It claims there's no such file as distutils.core, even though I can find that file myself. Any ideas where I'm going wrong? I've got all the databases ready to roll, and just need the DA to work. According to my system, the core.py file is in /usr/lib/python2.1/distutils/, and the setup.py file in the MySQL-python-0.9.0 directory reads: #!/usr/bin/env python import os, sys from distutils.core import setup from distutils.extension import Extension If I try to build or install this file, then I get an error saying: ImportError: No module named distutils.core Should I be changing some of the setup.py file? I can't see where the problem lies... Thanks in advance for any help. Andy Wade Leftwich wrote:
Your Access mdb file is on your Linux box? I don't think you can open it there. You'll need to put it on a Windows box, then talk to it via ODBC over the network.
Marc-Andre Lemburg's new and excellent mxODBC Zope Adapter will do the job. It's a bargain at $95 per Zope server. I'm using it on Windows, but have tested his mxODBC module on Linux, and it works.
mxODBC enables Python to talk to the ODBC driver manager on your Linux box. There are a couple of free ODBC driver mgrs available for Linux. Then for getting your Linux box to talk to the Access box, there are one or two free projects as well as commercial products (http://easysoft.com/).
If you don't need to keep the db in Access for other reasons, now would be an excellent time to take a good look at PostgreSql.
You can probably get more answers on the Zope-db list.
Wade Leftwich Ithaca, NY