[Casey Duncan]
"Thomas B. Passin" wrote:
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.
That is because Access is not a database server, it is a client-based database program.
Exactly.
My inclination would be to put a Zope installation on the Windows machine that has the Access database (you could copy the database every once in a while if it doesn't get updated too often. That way you could avoid putting anything on someone else's machine). Build Zope pages that return the data as lists, I would think, and get them into your Zope Linux installation that way.
You could get around this problem by using linked tables in Access. You can physically store the Access mdb file with the data in it anywhere so long as you can access that file over the network. Then setup Access on the Zope machine and create a database that just contains tables that are linked to the remote mdb file. Then you get completely live data all the time.
Ah, one of those Access things that I'd know about if I actually used Access as an application. All I ever do is get data from an Access database on those rare jobs where I'm forced to use someone else's Access database. Thanks for the knowledge. Cheers, Tom P