Options

MS Access

graffitigraffiti Posts: 2
edited April 18, 2007 2:52PM in SQL Data Compare Previous Versions
Do you support MS Access?
· Share on Twitter

Comments

  • Options
    Dave MellorsDave Mellors Posts: 34
    No, Data Compare does not support Microsoft Access.

    Data Compare is supported on SQL Server 7 and above.
    · Share on Twitter
  • Options
    lc6529lc6529 Posts: 30
    You can get around the access limitation by doing the following:

    #1: Setting up the Access database as a LINKED server to your SQL server.

    #2: Setup a SQL Database that consists of VIEWS to each table in your access database.

    I have done this and can sync the access database to my sql database.
    · Share on Twitter
Sign In or Register to comment.