Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Populate Form - SQL actions process

Author  Topic 

johnpapa
Starting Member

7 Posts

Posted - 2012-12-20 : 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?
   

- Advertisement -