Need help understanding definitions

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

HI!!

I hope I'm in the right place for this question.

I've just recently eared about n-tier technology.
What is it an can we use this inside Access, under another
name or explanation perhaps.

Can someone explain what this is, and if it relates at all
to any Access functions..

Thank you..
 
"N-tier" usually is used to refer to separate components in a distributed
processing system to perform specific functions: user interface and display,
business rules, and data manipulation.

In a typical n-tier application the user's machine would run the browser or
an application that communicated across a network (could be the Internet)
with a remote component that applied business rules (buzzword for
"application logic") and interacts with either another component or a
database to obtain/store data.

It doesn't really relate to Access, specifically, though every database
application has all these functions. They aren't separated into multiple
independent components.

If you had an Access client application accessing data in a Microsoft SQL
Server database on the network, that would be a TWO-tier application. User
interface and business rules in the Access client, data handled by SQL
Server.

Larry Linson
Microsoft Access MVP
 
Thank you very much for that clarification....
-----Original Message-----
"N-tier" usually is used to refer to separate components in a distributed
processing system to perform specific functions: user interface and display,
business rules, and data manipulation.

In a typical n-tier application the user's machine would run the browser or
an application that communicated across a network (could be the Internet)
with a remote component that applied business rules (buzzword for
"application logic") and interacts with either another component or a
database to obtain/store data.

It doesn't really relate to Access, specifically, though every database
application has all these functions. They aren't separated into multiple
independent components.

If you had an Access client application accessing data in a Microsoft SQL
Server database on the network, that would be a TWO-tier application. User
interface and business rules in the Access client, data handled by SQL
Server.

Larry Linson
Microsoft Access MVP




.
 
Back
Top