|
||||||
|
Database Server By Richard Rost 13 months ago Transform Access into a Database Server, Part 1 In this tutorial, I'll explore how to transform 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. Taylor from Shawnee, Kansas (a Platinum Member) asks: In your Cache Locally video, you showed us how to download a complete set of data from the back-end database, like all customers from Florida. However, our local workstation still has to pull all of the records from the back end. Isn't there a way to make the back-end database smarter so that it can figure out what we need and send us only that? Prerequisites
Up Next
Keywordsaccess 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
|
||||
| |||
Keywords: TechHelp Access issue command remote server, 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 1 |