RE: Front End or Backend - Where to put what?

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

From: BigDuke6UK (BigDuke6UK_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 08:15:23 -0700

First of all thanks for your replies.
I intend to run Access at both ends so it seems my approach as already been
decided i.e queries and code go at the Front End. However a further confusion
on my part is the tiered approach of 'Data Layer, Business Layer and
Application Layer'. My thoughts were to seperate 'data access' code and
relevant objects from the 'presentation code' relating to Form events and
reports and somwhere in between the two have the 'application layer' dealing
with all the business logic such as large scale queries, functions and
procedures and basically all the behind the scennes stuff the application is
being built for. I think I may be in danger of thinking too much and
confusing myself with abstract concepts and what is actually acheivable. Any
further comments?
Thanking you in advance.

"BigDuke6UK" wrote:

> I am designing a fairly large scale Access 2003 application. I intend to have
> a front end for around 20 clients and a server backend. Server is running Win
> 2003 Server and clients XP Pro. I am confused as to where I should put my
> code and stored queries, on the front end with the table data or on the
> backend. I have two very good books by my side but they contradict each
> other. Also a programmer friend of mine says that all queries and code used
> to access the data tables should be kept at the front end data layer but my
> thinking is that queries and code should take place at the back end in order
> to spare the server unecessary workload. Any help would be greatly
> appreciated as I am going round in circles at the moment.
>

Relevant Pages

  • Re: Multilayer applications
    ... > you from being able to make the direct database calls from your GUI. ... I supposed that GUI and the busuness logic layer are different instances. ... I use Sql Queries from my business ... Do you always use the Stored Procedures and never an implemented SQL code? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Multilayer applications
    ... comments to the idea of a layer of classes, ... It is OK if the business layer knows the following... ... > later in this message that you prefer to use the stored procedures instead ... I use Sql Queries from my business ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: n-tier
    ... There is a layer that is what some call the "glue layer". ... an xsd schema to represent all my tables, ... queries to get at my data. ... Do any web services go in the data layer, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [WARNING] Failed to query SPN registration on DC
    ... DNS server: User Specified DNS Server ... UDP port 53 responding to queries: ... iescrkads01.jw-uk.jameswalker.co.uk Unknown ...
    (microsoft.public.windows.server.active_directory)
  • Re: Non-existent A record being returned...
    ... ; Query 1 ... These DNS servers are set up to forward queries to two other DNS ... Nslookup has it's own resolver service, and doesn't rely or use Windows resolver service, or the local cache, but rather directly queries DNS, where I'm assuming you're referring to clearing the DNS server cache? ...
    (microsoft.public.windows.server.dns)