Microsoft visual basic 6.0 / Access alternatives

Posted on 2005-04-07
Last Modified: 2013-11-25
Microsoft visual basic 6.0 will be used as the Object Orientated Program (OOP) to create the front end of a small video store booking system (this is a uni assignment), this will then interact with the relational database management system (RDBMS) Microsoft Access.

I have been asked to research alternatives, what alternatives are there to create this sort of device.

Please give the RDBMS and then the OOP.

e.g. is Realbasic an alternative for visual basic 6.0 and can it be used with Access or any other RDBMS?
Question by:lukegriffiths110
    LVL 13

    Expert Comment

    I will recommend go directly to VB.NET
    First of all VB.NET is fully object oriented (VB 6 is NOT)
    As Back end MS SQL Server is natively supported by .NET framefork. But Access will be good enough.
    And if it is really SMALL video store - even flat XML file might work just fine as data storage.
    LVL 20

    Accepted Solution

    There are probably dozens of potential good answers to this question... the choice would probably be based on familiarity with the products and/or cost.

    RealBasic (the Professional Edition) can be used with most of the RDBMS's and with any ODBC compliant DBMS.  I believe it would be at least as good a choice as VB6.  I don't recommend using MS Access for the backend however... I don't think it is robust enough to store critical business data in (it's a great tool for ad-hoc analytical tasks, though).

    Other candidates are Java, FoxPro, xHarbour, Delphi for the OOP side and MSDE, MySQL, PostgreSQL, Cloudscape, Firebird, InstantDB for the RDBMS.  Java and xHarbour both have cross-platform capability (Linux & WIndows) as do the RDBMS's so they offer additional flexibility for deployment.  RealBasic is cross-platform between Windows and Apple Mac's but that probably doesn't translate into any advantage in this scenario.

    There are more viable possibilities but I'll leave them for someone else to suggest.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now