Solved

Access 97 vs VB 6

Posted on 2003-12-05
8
400 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
  • 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
 
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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

743 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

11 Experts available now in Live!

Get 1:1 Help Now