Hello,
New guy here. Very comfy with Access apps but just getting into SQL server. I have backend data set up and the App uses linked tables to pass data to local tables, e.g., I'm running local queries to grab data from linked tables to store them in local tables for doing calcs, etc. I'm wondering if using Views would help speed this up. For example, can I use a view to grab the same data and more quickly show the data. Not sure how to pass parameters to the View, and how to post the data to the local table. Also, if I show a View directly in Access, is the data editable?
Thanks for any help!!!
New guy here. Very comfy with Access apps but just getting into SQL server. I have backend data set up and the App uses linked tables to pass data to local tables, e.g., I'm running local queries to grab data from linked tables to store them in local tables for doing calcs, etc. I'm wondering if using Views would help speed this up. For example, can I use a view to grab the same data and more quickly show the data. Not sure how to pass parameters to the View, and how to post the data to the local table. Also, if I show a View directly in Access, is the data editable?
Thanks for any help!!!