"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
(MIDWEST)
301 Alexander Ave., Suite C
P.O. Box 726
Ames, Iowa 50010
Tel: (515) 239-9900
Fax: (515) 239-9800
Skype™

Driving Directions to the Ames Iowa Headquarters
Florida Headquarters
(Southeast)
4200 Evans Ave., Suite 10
Fort Myers, Florida 33901
Tel: (239) 267-2749
Fax: (239) 267-9936
Caribbean & Latin America
(Puerto Rico)
Tel: (787) 303-0042
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!!
Disclaimer
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 as long as 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 2014 Express Edition, which is capable of storing up to 10GB of data. Microsoft SQL Server 2014 Express Edition is also needed to support users working with the database via a web browser. Microsoft SQL Server is free and serves the needs of 95% of WSI’s customers.

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.