Need Resources on using ADP with SQL SErver 2005!

I

ibeetb

Please help! I need documentation on how to do this......can anyone poj t me
in the right direction? Would appreciate it
 
D

David Portas

ibeetb said:
Please help! I need documentation on how to do this......can anyone poj t me
in the right direction? Would appreciate it
Click to expand...

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.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
 
L

Lolik

Are you looking to learn .adp / SQL Server database design, or have you
programmed .adp with MSDE, and have problem upgrading to SQL Server 2005?
 
A

aaron.kempf

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Access 2000 ADP and SQL Server 2005 2
I have a document with 8 different templates on it. 1
Blank Page After Envelope-Label Wizard 5
ADP Error opening tables on SQL SERVER 2005 and Access 2007 5
SQL Server 2005 schema for Access 2007 ADP 2
ADP and SQL 2005 2
ADP Update Query does NOT update ! 3

Top