• banner

    “The PCA crew is leagues above
    the competition” - Pepsico

  • "a prior vendor failed to develop
    the application, which (Practical) delivered." - Franklin Park

  • "the application (is) easier to use, with a
    much simpler, more intuitive use interface" - Royal Administration Services

  • "Sometimes it's the things you don't ask for
    that are important" - Royal Administration Services

  • "PCA turned our raw data and algorithms into easy to use
    and understand features and reports." - CareScout

  • "The quality and professionalism ... has been
    so outstanding that we want to send you a letter of thanks." - USALCO

  • "PCA people and applications stand out by
    far exceeding our expectations." - USALCO

  • "The resulting application greatly increas(ed)...
    our business effectiveness and efficiency." - The Advest Group

  • "PCA completes projects
    efficiently and effectively" - Pepsico

Client-Server Application

Client-Server applications designed from source MS Access databases are typically written in Java or one of the Microsoft .Net languages (C#, Visual Basic .Net), and designed to run against a SQL Server or Oracle Database server. With a Client-Server migration approach, your source MS Access application serves only as a functional prototype for the new application — no components of the MS Access application are used following project completion.

 The result is high application performance, tight security and the most robust user experience. Application deployment can be automated and may be restricted to MS Windows PCs. As a true Client-Server application, with a relatively small local PC memory requirement, the Client-Server approach enjoys standard Windows deployment and security coupled with high-end database server performance and robust security.

Client-Server Scorecard

# End Users <: 1000 Supports continual use
Deployment LAN Only WAN or Internet use not recommended
Performance Excellent SQL Server design-dependent
Reliability Excellent SQL Server design-dependent
Data Integrity Excellent Assumes proper use of SQL Server database constraints and keys
Security Excellent SQL Server-level security controls
Data Limit Unlimited SQL Server datastore
Maintenance High Distributed application maintenance
# of Records Unlimited SQL Server datastore
Internet Access No Remote access will substantially impede performance and reliability

Client-Server Architecture

Typically deployed to a network share, MDE Access Client-Server applications are recommended for non-regulated, shared data across a LAN, for example, inter-department management of statistics and production analysis. MDE Access Client-Server applications are limited to LAN deployment. Large front-end applications can be slow to load over a WAN. The MS Access Client-Server approach does expose the data tables directly to the End User, which can present security or data integrity issues.

For help with your business application contact the Access Client-Server experts at Practical Computer Applications (PCA) at 877-843-3405.