Solved

Visual Basic Application vs. Microsoft Office Access front end

Posted on 2008-06-10
16
1,114 Views
Last Modified: 2010-04-21
What are the benefits of creating a Visual Basic application front end to a SQL server vs. a Microsoft Access 2007 front end client to a SQL server? Does someone know the pros and cons doing either?
0
Comment
Question by:tkschultz1207
[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
  • 5
  • 4
  • 3
  • +3
16 Comments
 
LVL 4

Expert Comment

by:albuitra
ID: 21754461
visual basic .NET is more portable. you could deploy in iPAQs, celullar phones, etc
access is more easy to design
0
 
LVL 3

Assisted Solution

by:NIMTUG_Simon
NIMTUG_Simon earned 50 total points
ID: 21754475
Using VIsual Basic you will be able to create more familar looking applications for your end users, Creating applications which work like other applications in Windows and Office ensure that your users get to grips with the application quickly.

It is more difficult to create things like reports in VB (I assuming that you are tallking about VB 6 rather than VB.Net) than access and depending on how complex your app is you will be able to do a access app relatively quickly. Saying that you are able to do alot more with VB.

IMHO currently access is really only for quick proto-types and small application with a very small user base. Building in VB6 (or better .net) will give you better experience in building your programming skills which will more sort after.
0
 
LVL 75
ID: 21754494
The main difference is   Access is Desktop based and VB.Net is web (browser) based.  So, you need to decide that first.  The learning curve for a .NET app is bound to be longer than using Access - *Depending* on your knowledge of Access and VBA ...

mx
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 
LVL 4

Assisted Solution

by:albuitra
albuitra earned 50 total points
ID: 21754512
VB is also desktop based
You can use windows forms in VB
0
 
LVL 75
ID: 21754553
"You can use windows forms in VB"

Yes ... you *could* - but ... you can do a lot more with Access.

mx
0
 

Author Comment

by:tkschultz1207
ID: 21754585
What about speed or performance do you get better performance with VB rather than MS Access?
0
 
LVL 4

Expert Comment

by:albuitra
ID: 21754627
IMHO you can better perfomance with VB .NET
With VB 6, I think is equal
0
 
LVL 75
ID: 21754644
"IMHO currently access is really only for quick proto-types and small application with a very small user base"

Oh boy.  That is soooooo *not* true.  !!!!

mx
0
 

Author Comment

by:tkschultz1207
ID: 21754837
So what I hear people saying is this:
Reason to pick VB:
Looks Better
Web Based
opportunity to enhance programming skills
Hard to design and make reports
Not necessarily faster than MS Access
Access:
Easy to design, get reports, desktop based

I am an Access programmer, so I am not seeing the benefits of going to VB since we will need a lot of reports and it is not faster...am I missing something here? Our user bases will probably be at max > 25 users at a time.
0
 

Author Comment

by:tkschultz1207
ID: 21754846
Sorry I meant less than 25 people at a time most likely around 5 at a time.
0
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 21754885
(VB) "Looks Better"

On the contrary .... just simply not true.

Speed .... dependent on so *many* factors - in either case.  

"am an Access programmer,"
So ... you will have very little learning curve.  Access desktop vs VB Webform desktop ... no comparison as I see.  But ...  if you need browser based ... Access is out of the loop for all practical purpose.

Number of users - again ... many factors influence this.  I have many multi-user apps - across LANS, WANS and Terminal Services - all running with essentially no problems - typically 10-50 users.  

mx
0
 
LVL 10

Assisted Solution

by:cool12399
cool12399 earned 100 total points
ID: 21757337
I'm assuming you mean VB (although doesn't really matter if .net).

1. More compatible. if you use MS Office, and users have different versions, *some* stuff might not work on older versions.
2. Looks better/more familiar.
3. Easily deployable.
4. More support. Much easier to get help in creating the VB app, as opposed to creating the MS office app. (There are some ppl that are very good, but much less than VB coders).

Only *real* advantage to doing it in MS Access 2007 is that it is much faster to do if you know what you are doing AND you know everyone has MS Access 2007.
0
 
LVL 10

Expert Comment

by:cool12399
ID: 21757340
PS the first part is VB. I.e., do it in VB.
0
 
LVL 14

Assisted Solution

by:rachitkohli
rachitkohli earned 50 total points
ID: 21757687
I could see some significant differences :

Please correct me if am wrong in any of my points

1. Cannot make DLL in Ms Access === Can be done in VB
2. Cannot make ActiveX in Ms Access === Can be done in VB
3. Cannot make command line Application === Can be done in VB
4. VB.NET has lot of differences i would say since it has a capability of making large size complicated  Web Applications. Lot of new support for things which where very complicated & time consuming to do, using APIs. For example .NET has wonderful classes for GDI+, Net Handling (Upload/Download), Cross language programming compatibilities, Threading classes, etcc.. the list is huge.

Hope my points does make sense..
0
 
LVL 75
ID: 21761397
Re 1,2 & 3 above.

The question is - does that really matter in this app?  And, you *can* reference a DLL or ActiveX control with no problem.

Again ... are you planning a desktop app or a browser based app?

mx
0
 

Author Closing Comment

by:tkschultz1207
ID: 31466748
Thanks for your help! This was very interesting.  I think we are going to go with VB because I found a programmer who will create and support the software, therefore I will not have to, and I can still connect to the SQL server tables if I want to use an access client to run queries and reports.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

729 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