Solved

Access 97 vs VB 6

Posted on 2003-12-05
8
405 Views
Last Modified: 2008-03-06
I've written several applications in Access 97 but am considering switching to VB 6. What are the advantages and disadvantages to this switch? Thanks.
0
Comment
Question by:Rerodrig
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 39

Expert Comment

by:stevbe
ID: 9882991
Access is much easier, especially if you already know it. Are you writing applications for your company or are you distributing to Clients? Why are you thinking about changing, perhaps we can address those reasons specifically for you.

Steve
0
 
LVL 2

Author Comment

by:Rerodrig
ID: 9883098
Well I'm actually going to get my hands on Visual Studio and I'd like to write to start writing enterprise level applications, albeit simple ones.  I'm starting to use APIs, OO4O to connect to Oracle, COM objects to connect to e-mail and fax servers ... what I'm trying to say is that at this level a lot of documentation is out there for vb but not as much for access vba.  I'd also like increase the number of users that can use an application and also take advantage of some of the multi-threading capabilities in vb.
0
 
LVL 39

Expert Comment

by:stevbe
ID: 9883149
if you are writing enterprise level apps and will be using COM+ objects you will need to write those objects in VB. You can still use Access (2002 and up) to bind a recordset to a form directly so you could have your COM+ component return an ADO recordset. You may want to consider linking to Oracle via DSN and also use passthrough queries so the work is done by oracle directly in Access. Access has multiple personalities, and I think that it's interface for users (forms) is still much easier to use than VB. That being said I have developed front ends in both Access and VB and apps built in VB are certainly easier to distribute.

Are you looking into .NET at all?

Steve
0
What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

 
LVL 2

Author Comment

by:Rerodrig
ID: 9883250
Well ... unfortunately, for company use, VB 6 is as far as I'm going to get for the next year.  At home though, I'd like to start using .NET.  I understand there is a steeper learning curve though- a lot has changed in terms of referencing, declarations, and I hear structure in general.  Are you using .NET already?  Have you developed web applications with ASP?
0
 
LVL 6

Expert Comment

by:Plamodo
ID: 9883291
As Steve says, Access is much easier to connect everything and tie it all together.

Some of the reasons I sometimes wish I was doing my projects in VB are:

1.  Tons of controls aren't available in Access, and the ones that are often have greater limitations than VB controls.  This is especially true in Access 97 compared to Access XP.  I have a plethora of examples :)
2.  You can't make a stand-alone executable in Access.  You are pretty much always stuck in the Access environment.
3.  A front-end in Access is easily in conflict with different versions of Access.  If all your users have the same version, great.. but if anyone is running something different, it can be a tricky proposition.
4.  VB is far more powerful than Access.
5.  Its easier to control database security when you run Access only as a backend instead of frontend and backend.

All that said, Access has tons of automation to make life simple.  I tend to gut out most of the automation, and program from within - in VBA.
0
 
LVL 39

Accepted Solution

by:
stevbe earned 25 total points
ID: 9883299
.NET is fairly different although I was able to pick up C# fairly easily, I would imagine that VB.NET should not be to difficult. I have written VB 6 COM+ components for business rules and data access to SQL Server for web apps but do not write enough ASP to speak confidently about it. I also am now working for a company that is not using .NET yet and my main focus here is MS Access, VB and WebSphere (unfortunately don't get much time for WebSphere) so I hear you on being stuck with old technology.

Steve
0
 
LVL 2

Author Comment

by:Rerodrig
ID: 9883402
Thanks guys this helps a lot.  Plamodo, I'd like to award points to you too but don't know how to accept multiple answers.  Thanks again.
0
 
LVL 39

Expert Comment

by:stevbe
ID: 9883433
you can post a request in community support to fix this "Split" and for future reference please see http://www.experts-exchange.com/help.jsp#hi69 for instruction on how to Split points.

Steve
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

622 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