There's no problem getting data from an Access database via ODBC as long as the ODBC driver and the database are on the **same Windows machine**. I've not been able to make this work when the server+odbc is on a different machine from the database. ... Another approach would be to get a python xml-rpc server running on the Windows machine. That would use mxodbc to get data from the database and return it to Zope using xml-rpc. This should be pretty easy to do.
There was a discussion on this list not-too-long-ago on this very subject, which seems to have resulted in a proxying database connection that has been used successfully to do this very thing. Look at the thread starting at http://lists.zope.org/pipermail/zope/2001-July/095091.html The most important one is http://lists.zope.org/pipermail/zope/2001-July/095159.html --jcc (not proxying)