All-in-one solution for Remote Access and Web Portal
To meet the multiple critical challenges and extend an existing Access database application to corporate networks and the Web, two alternatives are available to the IT departments or the ISV:
While the first option may have been viable in the go-go days of the 1990s, given today’s budget realities, it leaves the remaining question: "Which is better: Web-based or Web-enabled?"
At first glance, rewriting the application for the Web may seem to be the desirable alternative – and currently some companies are following this route. Rewriting the application as a Web-based solution lets the enterprise or ISV preserve the application branding and the relationship with the end-users. However, reengineering an existing, stable application with an existing installed base is hardly the best solution. This method can be a very costly undertaking – a serious problem in times of limited IT spending.
Rewriting an application also has the potential for introducing instability and added complexities into an otherwise stable program. What’s more, rewriting applications for the Web can mean introducing a static front-end to the application, sacrificing the rich interactive experience users have come to expect. This in turn usually leads to the need for additional user training to learn the new software interface. The greatest problem, however, may be the very long development and quality assurance time that re-engineered applications take – sometimes delaying the solution for years.
Web-enabled solutions, on the other hand, can be deployed without the need to rewrite or even modify existing applications. Instead, the application runs on a central web server and is published over the corporate network or the Internet to remote devices such as terminals, PCs, workstations, notebooks, wireless devices, and systems configured with minimal memory.
The Benefits of Web-Based Application Publishing is a reliable, fast and efficient way to publish applications while reducing the complexity and cost of enterprise computing. The application itself executes completely on the server, guaranteeing high application performance for all users, including those accessing over low-bandwidth connections.
Giga Information Group concludes that: "Although Web-based computing has captured the mindset of developers and the market, the tremendous installed base of Windows client applications cannot be converted all that quickly..."
Web-enabling will continue to have broad appeal as organizations attempt to simplify their IT environments.
TSplus technology can improve the performance of your Accounting, Retail Manager and many other Access database applications by up to 10 times faster.
Access database application requiring direct access to the actual data file will slow down significantly as the number of users and the size of the file increases. This is due to the nature of the flat-file database systems. Unfortunately this slowdown is not linear, but seams like an accelerating nature, especially once the datafile grows over the 100MB in size.
By moving the datafile and the applications accessing it onto the same physical computer, one can achieve significant improvement in speed and reliability.
We have done tests with 1GB Accounting datafile. The conventional setup where the data sits on the server and the accounting application running on the client workstation, a particular report took up to 8 minutes to process, having the same datafile on an TSplus server running the accounting application has improved the process significantly and reduced the required time to about 40 seconds.
We also had clients with ongoing corruption issues. After moving the system to TSplus technology not only the performance has significantly improved but the database corruption issue has also completely disappeared.
If your system have stability or speed issues, feel free to contact us for advice and help.
If you have any questions regarding TSplus please send an email to firstname.lastname@example.org