Re: VB Front End Access BackEnd

The pros/cons in my view:

VB:

Pro
Control arrays/create controls at runtime
Lighter weight app...does not require msaccess retail/runtime
More ActiveX components available for use in your app...possibly
richer UI

Con
Considerable additional cost to implement similar functionality to
Access (if possible at all)
Report tools suck

Access

Pro
Robust data controls
Rapid development... in some cases, many orders of magnitude more so
than VB...even if the VB developer is an expert
Report tools are excellent
If user has retail version of Access, they can create their own
queries/reports pretty easily.
Con
See VB Pro

The biggest factor favoring Access in my mind is rapid development. The
difference in cost to develop a given app is usually pretty huge.


--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


"DS" <bootybox@xxxxxxxxxxxxx> wrote in message
news:1Cppe.64347$NZ1.62292@xxxxxxxxxxx
> Albert D.Kallal wrote:
>> "DS" <bootybox@xxxxxxxxxxxxx> wrote in message
>> news:%0ope.3090$S62.418@xxxxxxxxxxx
>>
>>>What is meant by VB Front End and Access Back End?
>>>Can you convert Access forms to VB?
>>>Thanks
>>>DS
>>
>>
>> Well, do note that the programming language in ms-access is what we call
>> VBA. This programming language for purposes is the SAME language as VB6,
>> but we have a different forms model.
>>
>> A good development practice is ms-access is to split the database into
>> two parts. The so called Front End has all of the forms, reports, and VB
>> code. The back end is simply a mdb file shared on a server/file share.
>>
>> So, you "move out" all of the code, and application part of a ms-access
>> mdb file. This new application part is then installed on each computer.
>>
>> you can also do this split, and re-write the application part in VB and
>> place that on each computer (not a lot of advantages of doing this in
>> most cases).
>>
>>
> Thanks Albert. So I guess you as you say the reports are run from VB.
> That means you lose Access great reporting?
> Thanks
> DS


.

Relevant Pages

  • Re: Archbishop criticizes Israel for "safrificing innocent civilians"
    ... but you never present anything pro or con to relevant points. ... who substitues his own "doctrinal statement" for the Nicene Creed. ... That only proves that you have a knack for picking bad seminaries for ...
    (soc.religion.christian)
  • Re: whats the best
    ... The latest version of BlackIce Defender is 3.5 and it does block phone home ... > PRO: Easy to use, ... > CON: If you allow an app to go through, you have to go to it and modify it ... Cookie control doesn't stop 3rd party cookie. ...
    (comp.security.firewalls)
  • Pros and Cons of the top 20 Dem Pres contenders
    ... Pro: Articulate; ... Con: L.A. Law was kind of overrated now that you think about it. ... Technically still running for president. ... Con: Potential attack ad: "Sometimes Optimus Prime is a robot, ...
    (rec.sport.football.college)
  • Re: Best way to copy whole content of HD into another
    ... Pro: Should be thoroughly tested already and allow restore of data ... Con: Copies a lot of cruft if the filesystem isn't very full. ... Usually does special and sparse files great. ...
    (comp.unix.bsd.freebsd.misc)
  • Re: Hennessy hammocks...
    ... Any pro or con comments? ... As long as you've got two trees, you have somewhere to set up your ... The straps that come with the hammock are about three feet long, ...
    (rec.outdoors.camping)