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.
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 Connection2) DELETE record3) Destroy Connectionand keep on doing this all the time? |
|
|
|
|