Hi Pete,
If the data is all in ONE server you only need one connection, but you might need to specify the database name when accesing the tables, like
MyDataBase.dbo.MyTable.
HTH
Luis
>Hi All, I need to access VFP tables using VFPOleDb from various ( maybe six ) locations and relate them, am I right in thinking I need a separate connection object for each location ? the data is all on one server
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould