Microsoft Access 365 with SQL 2019

Kazim Mohammed Razvi 0 Reputation points Microsoft Employee
2023-05-24T13:14:22.9+00:00

Dear Support Team,

One of our customer is using Microsoft Access 365 with SQL 2012 and we wanted to check if Microsoft access 365 is compatibility with SQL Server 2019.

Thank you for the help in advance.

Regards,

Syed

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,788 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
390 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-05-25T05:37:25.6966667+00:00

    Hi @Kazim Mohammed Razvi

    For each new version of SQL Server, the default compatibility level will be set to the version of the Database Engine. However, the previous version's compatibility level is maintained for continued compatibility with existing applications. You can refer to this link: https://video2.skills-academy.com/en-us/sql/database-engine/install-windows/compatibility-certification?view=sql-server-ver15.

    I don't know Access particularly well. Do you want to connect to Access data source from sql server? Or connect Access to SQL Server? I found these links for you, maybe you can use them as a reference.

    https://video2.skills-academy.com/en-us/sql/integration-services/import-export-data/connect-to-an-access-data-source-sql-server-import-and-export-wizard?view=sql-server-ver15

    https://support.microsoft.com/en-us/office/connect-access-to-sql-server-050d88f3-b2d6-4e76-b6f9-f3c556f139ea

    https://support.microsoft.com/en-us/office/migrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979

    Best regards,

    Aniya

  2. Olaf Helper 44,501 Reputation points
    2023-05-25T08:59:17.6633333+00:00

    MS Access is a SQL client as any other tool/client and not aware of the SQL Server version connected to, so should work without issues.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.