Access: Can Microsoft Access Tables be updated automatically from SQL Server

Question

I'm almost completely new to MS Access. In Access 2013, can tables in Access be automatically updated nightly based on a SQL query? Or, if I create a table in SQL that's updated nightly, can that update Access tables nightly as well?

Thank you.

Of course it's possible, but it is far better to link the SQL Server tables in Access. — Andre
– Andre, Commented Dec 3, 2015 at 15:16
OK thanks. I'm working on learning the basics now. I just wanted to know if it was possible. — JM1
– JM1, Commented Dec 3, 2015 at 15:18

Gustav · Accepted Answer · 2015-12-04 12:55:16Z

1

You can in SQL Server attach an Access database file as a Linked Server server object. Then you have access to the tables of that database from within SQL Server.

However, the Access database will often have to be opened exclusively, meaning that it will fail if opened from another application, or - when opened from SQL Server - no other application can get access.

answered Dec 4, 2015 at 12:55

Gustav

56.5k7 gold badges33 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Access: Can Microsoft Access Tables be updated automatically from SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related