• 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

MS Access Client-Server (MDE)

The MS Access Client-Server configuration uses MS Access converted to an MDE format for deployment to End Users’ desktops — which are connected to any ODBC-compliant datastore such as SQL Server or Oracle. The MS Access Client-Server design gains all the benefits of SQL Server while maintaining the application front-end in MS Access, and represents the most common MS Access migration approach.

Properly designed to use the Database Server performance and security, the MDE type MS Access Client-Server approach supports MS Access migration with rapid development, ease of maintenance, data transactions and fairly robust performance. MS Access or its runtime engine is required for deployment, and the End User can easily get direct access to the data tables and queries

Standalone MS Access Application Scorecard

# End Users < 250 Supports continual use
Deployment LAN Only WAN or Internet use not recommended
Performance Good 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 Medium Need to maintain MS Access
# of Records Unlimited SQL Server datastore
Internet Access No Remote access will substantially impede performance and reliability

MDE Access Client-Server Limitations

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.