Re: VB Front End Access BackEnd

"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).


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@xxxxxxx
http://www.members.shaw.ca/AlbertKallal


.

Relevant Pages

  • Re: Sort of a mail merge question
    ... perhaps there is something about our giro printer that prohibits this? ... > ms-access to send out the data you need.. ... > Edmonton, Alberta Canada ...
    (comp.databases.ms-access)
  • Re: VB Front End Access BackEnd
    ... 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. ... Thanks Albert. ...
    (microsoft.public.access.formscoding)
  • Re: Thanks
    ... that the report writer is STILL one of the ... >Also, both forms, and reports in ms-access has what is ... >So, VB is a general development tool, and you can even ... >Edmonton, Alberta Canada ...
    (microsoft.public.access.forms)
  • Re: Users Do not have Access 2003 on their laptops
    ... You can run a 15 year old version of ms-access on a brand new pc. ... users upgrade, you simply upgrade them to access 2003 front ends. ... Edmonton, Alberta Canada ...
    (microsoft.public.access.formscoding)
  • Re: Find a file on the computer
    ... Are you trying to do this in side of ms-access? ... the full pathname to msaccess.exe would be: ... Albert D. Kallal (Access MVP) ... Edmonton, Alberta Canada ...
    (microsoft.public.access.formscoding)
Loading