I have making a adp linked to a sql server 2008 database.
As many users will have the adp frontend a key requirement is to reduce server load and minimise connections to the DB itself.
I have questions on the following elements, how do they handle connections? do they open and close as apprpriate, or are they a resourse hog?
1.Dcount
2.Setting a recrdsource of datasheet subform(to a sql string)
3.DoCmd.RunSQL
4.Settings a combbox recordsource in properties or in code(to a sql string)
5. the adp opening with no actions on DB? Any general issues
Many thanks in advance
As many users will have the adp frontend a key requirement is to reduce server load and minimise connections to the DB itself.
I have questions on the following elements, how do they handle connections? do they open and close as apprpriate, or are they a resourse hog?
1.Dcount
2.Setting a recrdsource of datasheet subform(to a sql string)
3.DoCmd.RunSQL
4.Settings a combbox recordsource in properties or in code(to a sql string)
5. the adp opening with no actions on DB? Any general issues
Many thanks in advance
