M
mark
I was successfully using an Excel spreadsheet with
VBA 'macro' code on a Win 98 client, that connects to an
Access .MDB file on a Win 2000 Server (Domain Controller)
using a connection string specifying the file
as "\\ABCServer\databaseFolder\sales.mdb".
After upgrading to XP Home Edition, the ADO code in the
spreadsheet failed to connect to the file giving "invalid
path" or "file opened exclusively by another user".
I understand, that Home Edition is not intended to join
Domains on the LAN. But, I also know of XP HE clients,
that have been successfully integrated with Win 2000
servers, by carefully coordinating the local XP acount
with a Domain User account on the server, though I don't
know the details.
--Mark
VBA 'macro' code on a Win 98 client, that connects to an
Access .MDB file on a Win 2000 Server (Domain Controller)
using a connection string specifying the file
as "\\ABCServer\databaseFolder\sales.mdb".
After upgrading to XP Home Edition, the ADO code in the
spreadsheet failed to connect to the file giving "invalid
path" or "file opened exclusively by another user".
I understand, that Home Edition is not intended to join
Domains on the LAN. But, I also know of XP HE clients,
that have been successfully integrated with Win 2000
servers, by carefully coordinating the local XP acount
with a Domain User account on the server, though I don't
know the details.
--Mark