eye.jpg
 
                      AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.885.3631
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems. Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
                            AMDG
https://tse3.mm.bing.net/th?id=OIP.I6QZIHu4JPQeqCj0mY_hBAHaHa&pid=Api&P=0&w=300&h=300
Options for Application Configuration
                             
There are several options for application configuration depending upon the requirements. This page outlines the various types used by AutoSoft. In all cases the appropriate amount of security will be applied as outlined in this page:
ExcelSecurity.htm
                             
Application Structure
                           
Name: Stand-alone   Read-only on Network Share   Cloud-based  
                             
Details: A self-contained file that performs all necessary functions and stores all of the data required by the App.   The App is stored on a Network shared drive. Multiple users can open the App and work on it simultaneously. All data is stored in a back-end database.   The master copy of the App and all data is stored in a Cloud database. A self-updating copy of the App is stored on every user's computer.  
Pros: Simplest to create and maintain.   Multi-user. All data stays behind corporate firewall.   Multi-user. Authorized users can work on the App from anyplace with an Internet connection.  
Cons: Single user. Version control issues if the App is to be used to evaluate different scenerios.   User needs to be on the corporate network to use the App.   Most costly to design and maintain. Emphasis must be placed on performance in anticipation of jittery or slow internet connection.  
                             
                             
Database Options
                             
Database   Pros   Cons
                             
Access   Free. Simplest to implement. Quite sufficient for most tasks. Easy to set up Backup and Restore procedures. No database server required.   2 Gigabyte limit. Prone to being left in an unstable state if a transaction is interrupted. Not Cloud-based.
SQL Server Express   Free. More stable, more features and faster than Access.   10 Gigabyte limit. Requires database server computer. Must establish backup and restore procedures. Not Cloud-based.
SQL Server   Essentially unlimited storage.   One time purchase. Requires database server computer. Must establish backup and restore procedures. Not Cloud-based.
Azure   Cloud-base. (SQL-Server in the Cloud). Essentially unlimited storage.   Requires monthly subscription.
Other Local (Progress, Oracle, MySQL, )   Use if the database is already operational for another App.   May need to purchase drivers to connect to the database. Not Cloud-based.
Other Cloud (Progress, Oracle, MySQL, )   Use if the database is already operational for another App.   May need to purchase drivers to connect to the database.
                             
                               
AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631
This web page was last updated at 06/07/2019 09:52 AM and is written in EXCEL!
AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach