I have an Access front end application that links to Access Back end tables located on a server. The Front End application is used by approx. 50 users, some internal and some thru Term Server. I am planning to convert the Backend access database to SQL server, but I am confused as to the number of user licenses I would need to purchase. If I create pass through queries and use one login id to SQL server for the Front end to use to access the SQL Server BE tables, will I need a user license for all 50 users or just one for the FE application? What about if I link the BE SQL Server tables to the FE? Will I need 50 licenses or just one? Thanks, Karen -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1
SQL is licensed on either a per server, per user, or per concurrent user basis - I don't know which. If it is per user - you will need 50 licenses. If it is per concurrent user - you will need enough licenses to cover the maximum number of users logged in at one time. This may be 50 or 1 depending on how your application is used. If the users use SQL server for other applications, they already have the license and will not need to acquire separate ones to run your access application. "kscheu via AccessMonster.com" <u7307@uwe> wrote in message news:7f489ab94e23a@uwe... >I have an Access front end application that links to Access Back end tables > located on a server. The Front End application is used by approx. 50 > users, > some internal and some thru Term Server. I am planning to convert the > Backend access database to SQL server, but I am confused as to the number > of > user licenses I would need to purchase. If I create pass through queries > and > use one login id to SQL server for the Front end to use to access the SQL > Server BE tables, will I need a user license for all 50 users or just one > for > the FE application? > > What about if I link the BE SQL Server tables to the FE? Will I need 50 > licenses or just one? > > Thanks, > Karen > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1 >
"Pat Hartman" <please no email@aol.com> дÈëÓʼþ news:eufQn2LbIHA.4180@TK2MSFTNGP06.phx.gbl... > SQL is licensed on either a per server, per user, or per concurrent user > basis - I don't know which. If it is per user - you will need 50 licenses. > If it is per concurrent user - you will need enough licenses to cover the > maximum number of users logged in at one time. This may be 50 or 1 > depending on how your application is used. If the users use SQL server for > other applications, they already have the license and will not need to > acquire separate ones to run your access application. > > > "kscheu via AccessMonster.com" <u7307@uwe> wrote in message > news:7f489ab94e23a@uwe... > >I have an Access front end application that links to Access Back end tables > > located on a server. The Front End application is used by approx. 50 > > users, > > some internal and some thru Term Server. I am planning to convert the > > Backend access database to SQL server, but I am confused as to the number > > of > > user licenses I would need to purchase. If I create pass through queries > > and > > use one login id to SQL server for the Front end to use to access the SQL > > Server BE tables, will I need a user license for all 50 users or just one > > for > > the FE application? > > > > What about if I link the BE SQL Server tables to the FE? Will I need 50 > > licenses or just one? > > > > Thanks, > > Karen > > > > -- > > Message posted via AccessMonster.com > > http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1 > > > >
drytfthgmgmvvgmjf u dr7i84g "²Ì´ä÷" wrote in message news:esQ6ksBsIHA.484@TK2MSFTNGP04.phx.gbl... > > "Pat Hartman" <please no email@aol.com> дÈëÓʼþ > news:eufQn2LbIHA.4180@TK2MSFTNGP06.phx.gbl... >> SQL is licensed on either a per server, per user, or per concurrent user >> basis - I don't know which. If it is per user - you will need 50 > licenses. >> If it is per concurrent user - you will need enough licenses to cover the >> maximum number of users logged in at one time. This may be 50 or 1 >> depending on how your application is used. If the users use SQL server > for >> other applications, they already have the license and will not need to >> acquire separate ones to run your access application. >> >> >> "kscheu via AccessMonster.com" <u7307@uwe> wrote in message >> news:7f489ab94e23a@uwe... >> >I have an Access front end application that links to Access Back end > tables >> > located on a server. The Front End application is used by approx. 50 >> > users, >> > some internal and some thru Term Server. I am planning to convert the >> > Backend access database to SQL server, but I am confused as to the > number >> > of >> > user licenses I would need to purchase. If I create pass through > queries >> > and >> > use one login id to SQL server for the Front end to use to access the > SQL >> > Server BE tables, will I need a user license for all 50 users or just > one >> > for >> > the FE application? >> > >> > What about if I link the BE SQL Server tables to the FE? Will I need > 50 >> > licenses or just one? >> > >> > Thanks, >> > Karen >> > >> > -- >> > Message posted via AccessMonster.com >> > http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1 >> > >> >> > >
yes ok "²Ì´ä÷" wrote in message news:esQ6ksBsIHA.484@TK2MSFTNGP04.phx.gbl... > > "Pat Hartman" <please no email@aol.com> дÈëÓʼþ > news:eufQn2LbIHA.4180@TK2MSFTNGP06.phx.gbl... >> SQL is licensed on either a per server, per user, or per concurrent user >> basis - I don't know which. If it is per user - you will need 50 > licenses. >> If it is per concurrent user - you will need enough licenses to cover the >> maximum number of users logged in at one time. This may be 50 or 1 >> depending on how your application is used. If the users use SQL server > for >> other applications, they already have the license and will not need to >> acquire separate ones to run your access application. >> >> >> "kscheu via AccessMonster.com" <u7307@uwe> wrote in message >> news:7f489ab94e23a@uwe... >> >I have an Access front end application that links to Access Back end > tables >> > located on a server. The Front End application is used by approx. 50 >> > users, >> > some internal and some thru Term Server. I am planning to convert the >> > Backend access database to SQL server, but I am confused as to the > number >> > of >> > user licenses I would need to purchase. If I create pass through > queries >> > and >> > use one login id to SQL server for the Front end to use to access the > SQL >> > Server BE tables, will I need a user license for all 50 users or just > one >> > for >> > the FE application? >> > >> > What about if I link the BE SQL Server tables to the FE? Will I need > 50 >> > licenses or just one? >> > >> > Thanks, >> > Karen >> > >> > -- >> > Message posted via AccessMonster.com >> > http://www.accessmonster.com/Uwe/Forums.aspx/access-conversion/200802/1 >> > >> >> > >
