|
johnpapa
Starting Member
7 Posts |
 Posted - 12/20/2012 : 01:53:01
|
As I get more involved with using ADO (Access) to connect to SQL Server, I am wondering how I can populate a form with the table fields using the Access wizard. There is no linked table to use, so I created a DSN which points to the db, created the link to the table, used this link to populate the form, then deleted the link and used ADO thereafter. Is there a more elegant way to populate the form?
Also, do I need to create and destroy the ADO connection for every action which I take such as DELETE, UPDATE, INSERT etc. In other words do I need to
1) Create Connection
2) DELETE record
3) Destroy Connection
and keep on doing this all the time?
|
|
Populate Form - SQL actions process
