I have an assignment and need assistance getting started. I'm not a d/b expert and my web research has not been fruitful.
We have a SQL-Server (2012) with a master d/b.
We also have many systems (various versions of Windows) using a local app that stores the same data in a local Access .mdb. The table structures are similar (not exact).
The project is to replace the .mdbs with some form of database that can be queried using the exact same SQL language as the SQL Server database. The new d/b will sit on the standalone system and occasionally receive updated record from the SQL server d/b.
We are looking for something that is free, and can be distributed with the app (VB6).
Any ideas, advice or direction would be greatly appreciated.