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)

  • 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 Lokad.com to remotely grab the sales and offer web-based sales forecasts (dislaimer: I am working at Lokad.com). – 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 clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.