K
kscheu via AccessMonster.com
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
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