Access 2010 front end with SQL Server 2014 Backend RRS feed

  • Question

  • This is a noob question but I really need help. Is there a way that I can connect my existing MS Access DB to SQL Server maintaining full functionality of MS Access.  I have tried the ODBC connection but some access functionality is lost... MS Access has a favourable interface for my users but I need the flexibility of SQL Server. What's the best way I can maintain MS Access as the front end? ADP's are not supported. I have an existing Database in Access but I need to use some SQL server queries. I would love for the same queries to appear as forms and reports in Access. How possible?
    Thursday, April 7, 2016 7:45 AM


All replies