Scaling Up with Unbound Access Applications "Patrick Jackman" <pjackman[ at ]wimse.com> 05.03.2006 19:33:18 In "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron write in chapter 11: "If your licensing allows you to keep a connection for each user open, however, that is usually the best choice in a two-tier system". What are the licensing issues they are referring to? How does this relate to MSDE? Are things different with the new SQL Server Express? Or does this licensing issue only apply to SQL Server Standard? Patrick =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Patrick Jackman Microsoft Access Developer since 1994 Vancouver, BC

Re: Scaling Up with Unbound Access Applications "Egon Kadula" <Stift 40.[ at ] AOL. com> 11.03.2006 14:57:51 "Patrick Jackman" <pjackman[ at ]wimse.com> schrieb im Newsbeitrag news:uKtpOuIQGHA.2816[ at ]TK2MSFTNGP15.phx.gbl... [Quoted Text] > In "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron > write in chapter 11: "If your licensing allows you to keep a connection > for > each user open, however, that is usually the best choice in a two-tier > system". > > What are the licensing issues they are referring to? How does this relate > to > MSDE? Are things different with the new SQL Server Express? Or does this > licensing issue only apply to SQL Server Standard? > > Patrick > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > Patrick Jackman > Microsoft Access Developer since 1994 > Vancouver, BC > >

Re: Scaling Up with Unbound Access Applications "Albert D.Kallal" <PleaseNOOOsPAMmkallal[ at ]msn.com> 14.03.2006 03:57:35 "Patrick Jackman" <pjackman[ at ]wimse.com> wrote in message news:uKtpOuIQGHA.2816[ at ]TK2MSFTNGP15.phx.gbl... [Quoted Text] > In "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron > write in chapter 11: "If your licensing allows you to keep a connection > for > each user open, however, that is usually the best choice in a two-tier > system". > > What are the licensing issues they are referring to? How does this relate > to > MSDE? Are things different with the new SQL Server Express? Or does this > licensing issue only apply to SQL Server Standard? Well, if you purchased a system that only allows 5 max users, or 10 max uses (10 user system), then keeping open a connection means that you will be limited to 10 users. Often a server based system is purchased based on the number of allowable connections. However, the new sql server express does not have these limitations...so, don't worry much... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal[ at ]msn.com http://www.members.shaw.ca/AlbertKallal

Re: Scaling Up with Unbound Access Applications "Patrick Jackman" <pjackman[ at ]wimse.com> 24.03.2006 19:21:40 Thanks Albert. Is it possible then to open as required and close connections immediately to accommodate a greater number of users. If there is a license for 5 users, is this likely to work for 20 application users? Is there a large performance penalty to opening and closing connections? I'm thinking about coding for the eventuality of growing beyond the size limits of SQL Express. Patrick. "Albert D.Kallal" <PleaseNOOOsPAMmkallal[ at ]msn.com> wrote in message news:OQ0DztxRGHA.1728[ at ]TK2MSFTNGP11.phx.gbl... "Patrick Jackman" <pjackman[ at ]wimse.com> wrote in message news:uKtpOuIQGHA.2816[ at ]TK2MSFTNGP15.phx.gbl... [Quoted Text] > In "Microsoft Access Developer's Guide to SQL Server", Chipman and Baron > write in chapter 11: "If your licensing allows you to keep a connection > for > each user open, however, that is usually the best choice in a two-tier > system". > > What are the licensing issues they are referring to? How does this relate > to > MSDE? Are things different with the new SQL Server Express? Or does this > licensing issue only apply to SQL Server Standard? Well, if you purchased a system that only allows 5 max users, or 10 max uses (10 user system), then keeping open a connection means that you will be limited to 10 users. Often a server based system is purchased based on the number of allowable connections. However, the new sql server express does not have these limitations...so, don't worry much... -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal[ at ]msn.com http://www.members.shaw.ca/AlbertKallal