“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 to .NET
If you have exceeded the built-in limitations of MS Access and are experiencing one or more problems, such as slow performance, unreliable data, corruption and error messages are common indicators, it may be time to reconfigure your MS Access application, or migrate the MS Access application to more powerful components to fix problems your are having or to meet more demanding business needs. Depending upon your situation, the right approach may involve replacing one or both MS Access application components: the back-end Jet Engine datastore and/or the front-end User Interface.
The table below shows the different MS Access migration options available. Capabilities in the chart increase from left to right — from a standalone MS Access application designed to support a small workgroup on a LAN, to a robust Internet-native database application capable of supporting hundreds of concurrent users. Click on the column heading to see more detail about the particular option or on the Learn more link to see how Practical Computer Applications (PCA) can help you.
| Capability | Stand Alone MS Access | Split MS Access | MS Access Datastore | MS Access Data Project | MS Access Client-Server | Client-Server App | Web Browser App | Smart Client App |
| # End Users | 5-10 | 5-10 | 5-10 | < 15 | < 100 | < 250 | Unlimited | Unlimited |
| Deployment | LAN Only | LAN Only | LAN Only | Desktop Only | LAN and Internet | LAN Only | LAN and Internet | LAN and Internet |
| Performance | Varies | Varies | Varies | Varies | Good | Good | Good | Excellent |
| Reliability | Good | Medium | Medium | OK | Excellent | Excellent | Excellent | Excellent |
| Data Integrity | Poor | Poor | Poor | Poor | Excellent | Excellent | Excellent | Excellent |
| Security | Poor | Poor | Poor | Poor | Excellent | Excellent | Good | Excellent |
| Data Limit | < 200 MBs | < 200 MBs | < 200 MBs | 1 GB | Unlimited | Unlimited | Unlimited | Unlimited |
| Maintenance | High | High | High | High | Medium | Medium | Low | Low |
| # of Records | < 50,000 | < 50,000 | < 50,000 | < 50,000 | Unlimited | Unlimited | Unlimited | Unlimited |
| Internet Access | No | No | No | No | Yes | No | Yes | Yes |
| Learn more | Learn more | Learn more | Learn more | Learn more | Learn more | Learn more | Learn more |