Which Microsoft Access database engine version is compatible of SQL server 2019

Saidulu Kodidala 6 Reputation points
2022-05-20T06:15:01.6+00:00

Which Microsoft Access database engine version is compatible of SQL server 2019

We are using the 2019 SQL version and we have encountered the SQL job termination issue due to Microsoft Access database engine version 2016 and it's working on SSIS package level(jobs are being terminated when we use the Microsoft Access database engine 2016 version and jobs are being worked while using the Microsoft Access database engine 2010)

Can anyone please help me figure out which Microsoft Access database engine version is compatible of SQL server 2019

Thanks,
Saidulu
8096086266

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,446 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 45,881 Reputation points
    2022-05-20T06:40:21.103+00:00

    Which Microsoft Access database engine version is compatible of SQL server 2019

    ????
    MS Access Data Provider = JET/ACE is to connect / read /write data to/from MS Access databases, has nothing directly to do with SQL Server.

    SQL Server supports all OleDB data provider for linked server, if that's what you mean.

    we have encountered the SQL job termination issue

    That's really to less on informations.
    Please describe more detailed what you are doing in which way and which exact error message do you get.

    0 comments No comments

  2. Seeya Xi-MSFT 16,571 Reputation points
    2022-05-20T10:02:52.267+00:00

    Hi @Saidulu Kodidala ,

    Welcome to Microsoft Q&A!
    Here is an related document for you: https://learn.microsoft.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

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No 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.