1

I have an external application that uses a MS Access database to store its data. I do not want to touch anything here, because the application works very good for me.

I have now created a own application and now I need the data from the MS Access database in my application. My application uses SQL Server.

Is it possible to sync the existing MS Access database with a new SQL Server database, so that I can query the MS Access database through my SQL Server?

I really don't want a linked table in MS Access because this can not work since I can not change the application that uses the MS Access database, and it would also be great if I don't have to query from the MS Access database.

I really need a tool the reads data from MS Access and writes it into my SQL Server and the other way around so they always have the same data.

Thanks in advance for your help.

Improve this question
4
  • You would need to add a Linked server to your SQL Server, which references the Access database. Take a look here: stackoverflow.com/questions/5873673/sql-to-access-linked-server Commented Dec 17, 2018 at 12:13
  • I tried to add this, but when i expand my server i get the following error: "Cannot initialize the data source object of OLE DB provider Microsoft.ACE.OLEDB.12.0 for linked server" Commented Dec 17, 2018 at 13:03
  • Did you consider the 64Bit driver issue? Commented Dec 17, 2018 at 13:28
  • As far as i understood is this one working with 64 Bit, is this correct? Or can you please explain it to me Commented Dec 17, 2018 at 13:41
Related questions
2
convert an MSAccess DataBase to an SQL Server database
2
Converting Access db to SQL
0
Link Access Database to Server Backend
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.