I have a client that will be converting their Accounting Sys to a version that runs on M/S SQL Server. We have two separate Front-End applications developed in Access/VBA that connects to the Accounting Sys using a DSN and ODBC connection to link up with specific tables (5).
The question is how to determine the number of CAL's that will be needed?? When I presented this question a few months ago the answer was pretty straighforward in that if 20 workstations will run the Access Front-End application then you will need 20 CAL's.
My thinking is ... and this is what I'm trying to make sure of and confirm .... Say if a workstation connects to the SQL Server, links up to the 5 tables but doesn't do anything but sits there. Will that CAL be freed up or will it still be counted as a CAL in use by SQL Server??? My thinking is the License is only counted as in use when something in the Access Front-End application executes something against the SQL Server, is that correct???