[Zope] MS Access interfacing

[Thomas B. Passin]

[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