Solved

Access 97 vs VB 6

Posted on 2003-12-05
8
401 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

910 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

22 Experts available now in Live!

Get 1:1 Help Now