Results 1 to 9 of 9
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: MS Access and Visual Basic

    Hello there,

    I am new to Visual Basic and have a question that may seem naive (apologies in advance).

    I am developing an application that will be used for educational purposes (free), and thus many of the users may be younger and not have MS Access installed on their machines.

    If I include connections to an MS Access database in my project, will it work on their machines? I was going to include the database I will be using in the installed package.

    I have noticed some applications like Franklin Covey Planner use an Access database in their package, but have not tested them on a machine that doesn't have Access already installed.

    Also, will I run into any licensing problems if I use an Access database included in my application?

    If this is a problem, I am open to alternatives.

    THANKS!

  2. #2
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    Kringen:
    If you are willing to use another database, I recommend downloading mySQL (http://www.mysql.com/downloads/index.html), the myODBC driver and winMySqlAdmin server. mySQL works on stand-alone PCs, in networks and on the internet, for small, medium and large scale databases. Read their licensing agreement. It's quite liberal. All this software is FREE. the installation is easy and VB6/ADO/myODBC works cleanly. If you still want to use Access tables, WITHOUT the users having to purchase MSAccess, you can create Access97-type databases and tables from within a VB6 application using the ADO Extension for DDL and Security.

  3. #3
    Join Date
    Jan 2004
    Posts
    2

    MySQL

    Thanks vududoc,

    I have used MySQL on Linux but haven't given it a shot on Windows yet.

    That is good to hear that I could use it!

    After I compile my application, will the user need the MyODBC driver too, or is that compiled into the end product?

    Thanks for your help!

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You should have no issues retrieving data from an ms access db regardless of whether or not it's installed on a given machine. Assuming you are using an external application and hitting the db via odbc or something comparable. I have written a few applications that use access db's through delphi etc.. it works fine.

  5. #5
    Join Date
    Jan 2004
    Posts
    184

    Re: MS Access and Visual Basic

    Yes you can. If you are connecting using ADO it doesn't matter if they have access or not.

    Try this control out, very useful:
    http://www.geocities.com/scirocco_ha/DataControl.htm

    Originally posted by Kringen
    Hello there,

    I am new to Visual Basic and have a question that may seem naive (apologies in advance).

    I am developing an application that will be used for educational purposes (free), and thus many of the users may be younger and not have MS Access installed on their machines.

    If I include connections to an MS Access database in my project, will it work on their machines? I was going to include the database I will be using in the installed package.

    I have noticed some applications like Franklin Covey Planner use an Access database in their package, but have not tested them on a machine that doesn't have Access already installed.

    Also, will I run into any licensing problems if I use an Access database included in my application?

    If this is a problem, I am open to alternatives.

    THANKS!

  6. #6
    Join Date
    Feb 2004
    Posts
    1

    Re: MS Access and Visual Basic

    I don't believe MySQL is free anymore. I tried using it for few months back and got calls from their sales people asking to buy it. After reading the license agreement on their web site, I shockingly discovered that MySQL is free ONLY if you make products that you give away for free. Anything else - licenses go from $400 and up (less for higher volumes).

    I don't think people still realize this - they may have to shell out after the fact...

    Nothing surprising though... lots of formerly free software is going commercial (Apache is a venerable exception! - so far...)


    Llloyd

  7. #7
    Join Date
    Feb 2004
    Posts
    1
    You only have to buy a commercial liscence for MySQL if you are selling software and do not provide the source code. You can use it freely if you don't distribute it as part of Non-GPL software.

    <QUOTE>
    Free use for those who never copy, modify or distribute. As long as you never distribute (internally or externally) the MySQL Software in any way, you are free to use it for powering your application, irrespective of whether your application is under GPL license or not.
    </QUOTE>

  8. #8
    Join Date
    Oct 2003
    Posts
    706
    Yes, and the point is, you should include the cost of any database that you use in the cost of your product. (If there is such a cost, then obviously your product is not "free" ... and that is okay!)

    Otherwise, you simply stipulate that your product requires that such-and-such a database already be installed on the host computer.

    Incidentally, imho, when people state that such-and-such a software package is "free," they're really being misleading. Since a person's time is never "free," the cost of supporting and maintaining it is always there. If the vendor of a product neglects to charge money for it, then the customer bears the full cost of supporting and maintaining "something he didn't write," instead of only a pro-rata share. Only a hobbyist wants to buy a "kit." You might well find that your product is more successful if you charge a reasonable sum for it and promise (and provide!) good support. Something to think about.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  9. #9
    Join Date
    Feb 2004
    Location
    Cali - Colombia
    Posts
    16
    So what about Interbase 6.0 it's free?, I believe it is, according i read into the borland page.
    A.C.C.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •