Results 1 to 7 of 7

Thread: Is MS Access license required if a .mdb file is created but never opened MSAccess?

  1. #1
    DCarrot is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    4

    Question Is MS Access license required if a .mdb file is created but never opened MSAccess?

    If Java code programmatically creates a .mdb file, programmatically populates it, then programmatically emails the db WITHOUT the db ever having being opened in Access, does this require an Access license?

  2. #2
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    24,435
    Required by whom - the sender or the receiver? From what I've read, Java can't build mdb file but can use existing Access file. Receiver doesn't need Access to work with the file, other apps can connect to the Access tables.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    DCarrot is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    4
    Without revealing too much off the clients proceedure ...

    A Supplier dictates that all orders are sent as .mdb files and provides a base file to my client.

    The software in question, used by my client, uses this base file to create an order populating it with the required items.
    The .mdb file is then emailed to the supplier.
    As stated earlier this is all done by the Java program without the Access application being opened.

    Quote Originally Posted by June7 View Post
    Required by whom - the sender or the receiver?
    Obviously it is up to the Supplier to ensure he has whatever license he requires for whatever he does with the .mdb file - this does not concern me.

    My question is, is a MS Access license required by the piece of software which programmatically populates and emails the .mdb file without ever having opened the file using the MS Access application.

  4. #4
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    24,435
    No Access license required for any app to connect to Access tables.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    DCarrot is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    4
    Many Thanks for the prompt reply.

    Is this the official MS line?
    Do you know of any documentation to support this?

  6. #6
    June7's Avatar
    June7 is online now Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    24,435
    It is a logical conclusion. I can't find anything 'official'. Access tables are used by developers as data storage component of an application. The front end can be developed in any programming application (Access, Visual Basic, Java, etc) that can connect to Access tables. Developer then offers package for purchase. As an example, we have a program called MicroPAVER that uses Access tables for data management. I don't know what the executable frontend was programmed in. I could run MicroPAVER without having Access but because I have Access and the backend Access file is not protected I can open it and interact directly with the tables.

    Even an Access db can be converted to an executable and distributed to users who don't have Access.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  7. #7
    DCarrot is offline Novice
    Windows Vista Access 2010 64bit
    Join Date
    Feb 2012
    Posts
    4
    Many thanks

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Close and Save Excel file already opened in Access
    By DB2010MN26 in forum Programming
    Replies: 7
    Last Post: 01-19-2012, 04:50 PM
  2. Replies: 0
    Last Post: 12-08-2011, 07:12 AM
  3. Replies: 13
    Last Post: 10-12-2011, 11:48 AM
  4. Replies: 1
    Last Post: 01-09-2011, 12:04 AM
  5. Replies: 1
    Last Post: 09-27-2010, 09:10 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums