MS Access db via ODBC on Mac?

[Alex Rice]

On Thursday, November 21, 2002, at 07:53  AM, Terry Vogelaar wrote:

> Hello all,
>
> I am developing an application that makes a real estate magazine from 
> text
> data in an MS Access database. The layout part is already working - I'm
> using AppleScript to communicate with Adobe InDesign.
>
> But the ODBC connection gives me a headache. I can connect RR to the
> database on a Windows PC, but than I cannot use the AppleScript part 
> there.
>
> Is it possible to connect with ODBC to a local MS Access database on a 
> Mac?
> How?

Mac OS X or Mac < 9?

OS X jaguar comes with the iODBC driver manager. Tuviah said that Rev 
2.0 is going to support iODBC. Woohoo! Then you will be able to connect 
from Rev to MS Access running on Windows. Unless there are driver 
issues. Don't know.

Off topic: I would love to figure out how to get MS Excel X on a Mac 
connect to ODBC server, Access or otherwise. It doesn't seem possible 
though. Anyone think otherwise?

> If it can't be done, could I connect to that Windows PC in any way? 
> There is
> a LAN connection with that PC using PC-MAC LAN 8.

That should give you access to the filesystem and printers on the 
Windows machine, and not much else.

Alex Rice, Software Developer
Architectural Research Consultants, Inc.
alrice at swcp.com
alex_rice at arc.to