Tech Note: SQL Based Software Solutions

Sunday Business Systems offers SQL versions of our standard products.  From the user perspective, the SQL based software solutions are identical to our demo version except the underlying data is stored in Microsoft SQL tables.  The user interface, or Microsoft Access front end, connects to the SQL back end through our proprietary DSN-less Technology.  Our DSN-less Technology allows easy connection without having to create and maintain individual ODBC links from each user’s computer.

SQL Data Flow
Figure 1. Overall network structure of SQL product

SQL versions provide a higher level of data and user security while providing the same user experience and performance.  SQL administrators may add additional levels of user security and automated back-up strategies to protect sensitive company data.

To install the SQL version of our product, your company must provide the Microsoft SQL server and the database administration.  We will provide the database files for installation.  Free versions of the Microsoft SQL Server (Server Express) are available if your company does not already have a SQL server installed.

Once purchased, you will receive the software via email. The software is in 2 parts: a Microsoft Access front end and a SQL Back-end. Your IT folks will need to install the back-end SQL database on your SQL server, save the front end database on a network file server, and link the front end to the back end.

The installation process is simple and usually takes less than 15 minutes.

The SQL based product also solves the problem where 32 bit and 64 bit users must share the application.  The SQL based product allows 2 different front end user interfaces to share the same data (one 64 bit and one 32 bit front end application).

Server Requirements:

Any windows server computer running Microsoft SQL Server 2012 or later; or Microsoft SQL Server Express 2012 or later.
(Microsoft SQL Server Express is a version of Microsoft’s SQL Server relational database management system that is free to download, distribute and use. It comprises a database specifically targeted for embedded and smaller-scale applications.)

User Requirements:

  • Microsoft Windows 7, Windows 8.x, or Windows 10
  • 64 MB of RAM
  • 40 MB of available hard disk space
  • Microsoft Access 2013 or later

(if you do not have Microsoft Access, you may download a free runtime version from the Microsoft website)

For additional information contact:
Sales@SundayBizSys.com
Tel: 408-217-9680

Click here to download the full Tech Note.