|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|