Insert, update, delete data stored in SQL Server through adp

[Xiaolu]

Hello, there, I am trying to learn adp and got some questions. I
downloaded a SQL Evaluation from Microsoft and made a simple DB. Then
I create a adp using Access 2002 by choosing 'existing data'.
Everything is fine, I can see the tables I built in SQL Server and I
can make new tables, views. etc. But I still have not figured out how
to add new data to the table, update the records or delte records.
Any instructions are appreciated.
Pablo

 

[Vadim Rapp]

X> Hello, there, I am trying to learn adp and got some
X> questions. I downloaded a SQL Evaluation from
X> Microsoft and made a simple DB. Then I create a adp
X> using Access 2002 by choosing 'existing data'.
X> Everything is fine, I can see the tables I built in
X> SQL Server and I can make new tables, views. etc.
X> But I still have not figured out how to add new
X> data to the table, update the records or delte
X> records. Any instructions are appreciated.

Double-click on a table, and it will open, and you will be able to work with
the records. Make sure the table has primary key.

You'll find more information in Help that you can call from Access menu.


Vadim