In my ongoing development of a SQL Server back-end / Access adp front-
end migration from and mdb, I'm encountering an issue I cannot
understand that seems to relate to permissions under the adp.
The system configuration includes a test server running SBS 2003 R2

I have an Access front end that connects to a SQL database.  I recently
installed SQL Server 2005 on a WIN XP machine and successfully restored the
database etc.   I am able to connect to the database if I am on the same
computer as the SQL Server install.  However when ...

I have an Access 2000 adp client working with SQL Server 2000.
I have an adp form and a subform. The subform is populated from an ado
recordset:
Dim RS as new adodb.Recordset