Hi Michael --
Well, through Automation you could instance an Access.Application and look at individual Forms in the MDB .... so, you could create an Access form with a list, for lookup purposes, and call that form.
Details on how to do this can be found at:
http://www.microsoft.com/officedev/articles/Opg/003/003.htmIf you want the raw data, you're stuck with ODBC :-)
>I'd like to link my application to some Access data on the network. I will not be changing the data, just really using it as a lookup table. What it the cleanest way to do this in VFP6? I'd like to avoid installing and setting up an Access ODBC driver on every machine that uses the application - if I can!
>
>TIA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05