?
Solved

Visual Basic Application vs. Microsoft Office Access front end

Posted on 2008-06-10
16
Medium Priority
?
1,116 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 200 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
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
LVL 4

Assisted Solution

by:albuitra
albuitra earned 200 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 1000 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 400 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 200 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
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 …
Suggested Courses
Course of the Month8 days, 23 hours left to enroll

764 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