Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a Microsoft Access 2007 database that we would like to mirror as SQL database (typically MSSQL or MySQL, but we are flexible here). The mirrored database is only used for read-only purposes. However, the mirror should be kept relatively up-to-date.

Is there any fully automated way to achieve this mirroring? (commercial tools would be OK too)

share|improve this question
What is your actual scenario? What purpose is that SQL Server "mirror" of your A2007 database going to serve? – David W. Fenton Sep 28 '11 at 23:28
Scenario: legacy ERP based on Access holding sales data. Online sales data mirroring to enable to remotely grab the sales and offer web-based sales forecasts (dislaimer: I am working at – Joannes Vermorel Oct 3 '11 at 6:43
Is the ACCDB/MDB file locally accessible ot the SQL Server? If so, why not mount it as a linked server, and the it will look like it's just SQL Server. – David W. Fenton Oct 5 '11 at 17:39
Unfortunately, the ACCDB/MDB file is NOT locally accessible from the SQL Server. – Joannes Vermorel Oct 10 '11 at 8:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.