ADP supports SQL Server 2005 for data manipulation only, not for
modifying objects. What is it you want to do?
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
technically ADP does allow you to make SOME design changes to SQL
objects but not very many.
i believe that you can update views about half the time; and i have a
gumption to try using Access 2000 ADP (i prefer that interface anyways)
because i've got this gut feeling that they would work for sprocs in
SQL 2005.