Would someone please explain the technique(s) used to manage table and stored SQL links to remote database(s) using code. I know it's available through the Export/Import/Link menu; however, there must also be a method for using code to add, delete, and change these links once established...
Fellow Programmers. Does anyone know, from experience or reading, which is more efficient?
strSQL = "Select * from ..."
Docmd.RunSQL strSQL
or
Me.Recordsource = strSQL
1. Single user.
2. Network.
Thanks,
mac318
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.