Hello all,
So I've recently moved my split database back end to an SQL Server 2014 Express. My front end is Access 2013, and all of my queries are located in the forms on the front end. I have a few questions regarding the queries...
Questions:
1a)Can you use queries in Access front end that are created on a SQL Server back end? If yes, I would greatly appreciate a reference link!
1b)When dealing with my front end, should I create the queries here, or should I create the queries in the SQL Server?
2)Which way will load the forms with the data quicker(performance)?
3)Any pros and cons of using either way?
More info: I'm not sure if this helps at all, but about 90% of my queries are going into forms where data CAN BE edited. When using queries from SQL Server can you edit the data in an Access form?
Thank you!