Post reply

License Requirements - SQL Back end - Access Front End

  • November 30, 2006 at 5:57 pm

    #68555

    I am trying to figure this out and just can't.

    I am about to switch our access databases from an Access back end to a Sql Server Back end. 

    I am going to be reading all these posts on this forum to help me learn quickly.  Thanks in advance.

    But the very first question is what do we need to install on each user's workstation (what licence is required - so we can either buy it or know that we have it already) so we can do this.

    I would really appreciate an answer.  I have been googling for hours and just can't find a definitive answer. 

  • December 1, 2006 at 1:04 pm

    #675259

    Carolyn,

    If you want to use SQL Server to store your data and use Access as the front end to query and create reports from a client work station, you will need a licensed copy of Access on each client work station as well as a licensed copy of SQL Server on the server.

    First you will need to determin which edition of SQL Server will meet your business needs (http://www.microsoft.com/sql/editions/default.mspx).  You will need an Enterprise, Standard, or Workgroup Edtion.  The Express and Developer Edition will probably not be appropriate.  Then you will need to pick a licensing option (http://www.microsoft.com/sql/howtobuy/default.mspx). 

    At my last employer, I was charged with a similar project. I was to change the datastore to SQL Server, but retain all the existing queries and reports in the various Access databases.  We had about 200 networked PC's, about 20 Access users and we used SQL Server Standard Edition with a Per-Processor license.

    Regards,

    Jon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply