Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Database Server 5 < Database Server | Buttons on Reports >
Database Server 5
By Richard Rost   Richard Rost on LinkedIn Email Richard Rost   8 months ago

Transform Access into a Database Server, Part 5

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Join Now

This is Part 5 of my series on transforming Microsoft Access into a makeshift database server. This can be a handy solution for small-scale applications and proof-of-concept projects. We will pass SQL statements to an Access back-end database that will process our requests and send only the data we need back to the front-end. This is much like what a real database server, such as SQL Server, does.


Members will learn how to enable the back-end server to handle requests from multiple users. We'll learn how to lock the server so that only one person at a time can send a request, process the data, and copy the files that the user needs down to the local workstation. After that, we'll unlock the server so the next user can send a command. While this setup is not as robust as an actual database server like SQL Server, it will get the job done for multiple users.

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!



In the Extended Cut, I added 1.3 million records to the back-end database, moved it to my actual server, and tested the performance. Running a classic query just from the Access front-end took 30 seconds (get all customers from Florida). Using the database "Server" routine we built in this series took 9 seconds, and I'm sure that could be optimized even more if you took the time to.

Learn More

FREE Access Beginner Level 1
FREE Access Quick Start in 30 Minutes
Access Level 2 for just $1

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates


Mailing List - Get emails when new videos released
Consulting - Need help with your database
Tip Jar - Your tips are graciously accepted


Please feel free to post your questions or comments below or post them in the Forums.

KeywordsTransform Your Microsoft Access Back-End into a Makeshift Database Server - Part 5

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, database server, sql server, back-end, front-end, split database, linked tables, pass-thru query, timer loop




Comments for Database Server 5
Age Subject From
6 monthsDatabase ServerChris Bezant
7 monthsDatabase Server over internetGarry Smith
8 monthsHow to send other commandsJeff Bartuch
8 monthsPure Genius RichardJeff Bartuch
8 monthsVery interesting BUTGary James


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Database Server 5
Get notifications when this page is updated

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 7/15/2024 4:48:47 PM. PLT: 1s
Keywords: TechHelp Access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, database server, sql server, back-end, front-end  PermaLink  Transform Your Microsoft Access Back-End into a Makeshift Database Server - Part 5