Linked Server - Query

Hey all,
I have an Access app that need to be able to Query a Linked Server. The
Linked Server points to an Access Database. When I put the Access App on th
e
SQL Box where SQL 2000 and the Linked Database reside, I am able to Query th
e
Linked Server from the Access App with a SELECT or SP containing a statement
such as:
"SELECT * FROM PCCW...TRANS"
But when I try to run this same Query from the same Access App on any other
machine, I get the error:
"Cannot start your application. The Workgroup information file is missing or
opened exclusively by another user"
Any help is appreciated as always!
Thanks,
GerardHi Gerard
Have you checked out
http://msdn.microsoft.com/library/d...serr_2_6jzt.asp
John
"Gerard" wrote:

> Hey all,
> I have an Access app that need to be able to Query a Linked Server. T
he
> Linked Server points to an Access Database. When I put the Access App on
the
> SQL Box where SQL 2000 and the Linked Database reside, I am able to Query
the
> Linked Server from the Access App with a SELECT or SP containing a stateme
nt
> such as:
> "SELECT * FROM PCCW...TRANS"
> But when I try to run this same Query from the same Access App on any othe
r
> machine, I get the error:
> "Cannot start your application. The Workgroup information file is missing
or
> opened exclusively by another user"
> Any help is appreciated as always!
> Thanks,
> Gerard