I want to upsize an Access DB to SQL Server. But I still want to be able to write to the Access DB. Will the data written to the Access DB dynamically push to the SQL Server DB?

Refer this link

https://support.office.com/en-au/article/Import-or-link-to-SQL-Server-data-a5a3b4eb-57b9-45a0-b732-77bc6089b84e

--PRashanth

Hello

You can upsize to SQL Server your access tables then create linked tables on Access, these tables will appear on Access as they were created on Access but they are really located on SQL Server. This way your Access database will work as front end (your VBA programming code, reports, forms) and SQL Server as backend (with your data). However there are some changes you may have to do on your VBA code and queries.

http://www.mssqltips.com/sqlservertip/1480/configure-microsoft-access-linked-tables-with-a-sql-server-database/

When you upsize you cannot avoid making some changes to your VBA code and access queries.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator 10 hours 1 minutes ago

Hello

You can upsize to SQL Server your access tables then create linked tables on Access, these tables will appear on Access as they were created on Access but they are really located on SQL Server. This way your Access database will work as front end (your VBA programming code, reports, forms) and SQL Server as backend (with your data). However there are some changes you may have to do on your VBA code and queries.

http://www.mssqltips.com/sqlservertip/1480/configure-microsoft-access-linked-tables-with-a-sql-server-database/

When you upsize you cannot avoid making some changes to your VBA code and access queries.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Friday, March 20, 2015 9:03 PM