>You learn something new everyday. Open Database Connectivity (ODBC) sounds like a viable solution on my quick internet search.
>
>However, my shop is generic, FoxPro and Access with no utilites allowed, unless approved by the PC police.
>
>I can't believe MicroSoft doesn't have a better solution between its own two products
>
>Ernie
Most Access applications have a DSN in the ODBC. Then it would be just a matter of:
lnHandle=SQLCONNECT("MyAccessDSNinODBC")
lnSuccess=SQLEXEC(lnHandle,"SELECT * FROM MyAccessTable","MyVFPCursor")
But, you can also do it with the Access Object (if you want to get Geeky and avoid the ODBC).
oAccess=createobject('Access.Application')
oAccess.OpenCurrentDataBase("MyAccessMDBName") && etc!
Imagination is more important than knowledge