locked
Question about MS Access license RRS feed

  • Question

  • Hello

    I have written a code inside an Excel chart, that reads and writes data to an MS Access database.

    The connection string is defined as follows:

     .ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0; Persist Security Info = False;" & _
            "Data Source=\\server\folder\MyDatabase.accdb;"

    Do the users who use this excel, need an MS Access license, since it uses an Access database?

     

     

    Thursday, May 5, 2011 5:13 AM

Answers

  • poppe2 wrote:
    > I have written a code inside an Excel chart, that reads and writes
    > data to an MS Access database.
    >
    > The connection string is defined as follows:
    >
    > .ConnectionString = "Provider=Microsoft.Ace.OLEDB.12.0; Persist
    >        Security Info = False;" & _ "Data
    > Source=\\server\folder\MyDatabase.accdb;"
    >
    > Do the users who use this excel, need an MS Access license, since
    > it uses an Access database?
     
    In my oppinion: No.
    If they don't use Access as a program but only an Access
    database file.
    It's a common use of mdb/accdb files to hold the data of
    applications that are made with other programms or
    programming languages like VB etc.
     
    Also the OLEDB driver is freely available, e.g. here:
     --
    cu
    Karl
    *********
    Access-FAQ (German/Italian): http://www.donkarl.com
     
     
    • Marked as answer by Bruce Song Tuesday, May 17, 2011 12:45 PM
    Thursday, May 5, 2011 7:00 AM