Hello,
I am looking to move my Access 2013 database into SQL Server 2017 Express, and use Access 2013 as my front end.
Is there any guidance or instructional documentation on the best approach for using SQL Server 2017 Express as my back-end and Microsoft Access 2013 as my front-end?
In Access 2010, the missing manual book, it states that you can add objects to SQL Server, your tables and queries, while using Access as your front-end to hold the forms and reports -- I'm curious, is it the same for Access 2013? I've noticed there's been changes since the 2010 edition.
I'd still like to use my 2013 Access database as the front-end, but split the database and have my tables and queries in the SQL Server, what is the best approach to start that procedure?
Any help would be appreciated. Thank you.