Re: VB Front End Access BackEnd

Tech-Archive recommends: Fix windows errors by optimizing your registry


>> 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

Yes, that is correct. You got some great advice here from other posters. As
I mentioned, you do want to split the ms-access into two parts, and you
don't need to re-write any code to do this. This split approach thus gives
you a development environment where you have the program part, and a data
file part (just live VB, or most systems).

You can read about splitting here:
http://www.granite.ab.ca/access/splitapp.htm

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


.

Relevant Pages

  • Re: inline sql comments in access 2007 ?
    ... to display details for the objects in question (form, reports or in your ... Albert D. Kallal (Access MVP) ...
    (microsoft.public.access.queries)
  • Re: Programically Merging Data and Input Mask
    ... since you can create a expression, then during export, or even for reports, ... There is no need at all to store this value, or even as you ask...have users ... Albert D. Kallal (Access MVP) ...
    (microsoft.public.access.formscoding)
  • Re: Displaying lookup values
    ... since the combo box displays description, but *stores* the id, you an go: ... the form (I tend to prefer this approach for reports, ... Albert D. Kallal (Access MVP) ...
    (microsoft.public.access.forms)
  • Re: Script to get access versions
    ... reports that you need here: ... Albert D. Kallal (Access MVP) ... Edmonton, Alberta Canada ...
    (microsoft.public.access.conversion)
  • Re: How to Convert Access Transform/Pivot Query for SQL Server
    ... There is no tool,script,function to re-write it for ... Look at CASE expression to deal with such kind of queries. ... Also,permit me to suggest you perfoming such reports(if you need to make a ... > query being re-written for SQL Server using these two constructs. ...
    (microsoft.public.sqlserver.programming)