"We have been very pleased with the competent, prompt and courteous service they have provided to us."

Stu Perlman
Monarch/USESI (New Jersey)

Access Front End and Back End Explained

Access Front End and Back End Explained

Iowa Headquarters
103 E. 6th St., Suite 101
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Minnesota Headquarters
(Upper Midwest)
119 Washington Avenue N, 2nd Floor
Minneapolis, MN 55401
Tel: (612) 286-0675
Los Angeles, California
Tel: (310) 295-9562
Springfield, Missouri
Tel: (573) 213-2173
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 708-6025
South Dakota - Sioux Falls
Tel: (605) 496-9580
Texas - Austin
Tel: (512) 593-1056
New Mexico - Albuquerque
Tel: (505) 289-1364
Iowa/Illinois - Quad Cities/Muscatine
Tel: (563) 316-2378
North Carolina - Asheville
Tel: (828) 278-2323
Want quick Answers?
During normal business hours you can reach us via our live chat program.  Try it, it's really cool!!
Click Here To Chat With Us Now Live!!
Winning Solutions Inc. is an independent service provider for THIRD PARTY PRODUCTS where WSI provides support on remote, chat and over the phone basis for issues related to computer software. All other trademarks, registered trademarks, company names, product names and brand names for the third party trademarks are the property of their respective owners, and WSI disclaims any ownership , right , affiliation or endorsement of or by any such third party. The use of any third party trademarks, logos or brand names is for informational purposes only.

Access Front End and Back End Explained

Access Front End and Back End Explained

Database systems are comprised of a Front End and Back End. The term Front End refers to the user interface which consists of the screen forms and reports. The Back End has the tables that store the data, including the relationships between the tables, data queries and other behind the scenes technology that accepts information from and displays information to the user via the Front End.

In a Microsoft Access database, it starts off as a single Microsoft Access computer file containing both the Front End and Back End. The file extension is .mdb prior to Access 2007 and .accdb for Access 2007 and later. This single file arrangement works fine for a single user. If the database has more than one user, it should be “split” into a separate Front End file (FE) and Back End File (BE). This will allow the database to operate well for up to 10 concurrent users and if the BE does not need to be used over the Internet. So, it works fine on computers networked in the same office.

If some or all of the database users will be working with the database via a web browser Front End instead of a Microsoft Access FE a different process is used to create the FE. A web browser based Front End cannot be created in Microsoft Access it has to be programmed using languages such as VB.NET or C#.NET in Microsoft Visual Studio.

If the database will be storing more than 2GB of data, you will need a more powerful BE than the one included with Microsoft Access. Microsoft offers Microsoft SQL Server 2017 Express Edition, which can store up to 10GB of data. Microsoft SQL Server 2017 Express Edition is also needed to support users working with the database via a web browser. Microsoft SQL Server Express is free and serves the needs of 95% of WSI’s customers. Larger more powerful paid versions of Microsoft SQL Server are available for those with greater needs. WSI also offers a "cloud" version knows as Microsoft Azure SQL.

WSI does not recommend SharePoint or Office 365 as a FE or BE for your database. The reason is that Microsoft limited the functionality of SharePoint and Office 365 to inhibit people from creating malicious software that would be on Microsoft’s servers.

It is universally accepted that file sharing services such as Google Drive, OneDrive, DropBox etc. should not be used to make an Access database accessible via the Internet. Contact WSI to discuss what options for sharing your Access database via the Internet are right for you.