Does Compact and Repair affect linked tables?

Question

I have an Access 2010 database with several linked tables to an external SQL database.  I want to know if using the compact and repair feature will affect either the Access linked tables or the original SQL tables.

Answer 1

I use linked tables extensively, and thankfully, have never seen any evidence whatsoever that linked tables are affected in any way by the "Compact and Repair" utility in Access. They should be safe from this. It is my understanding that the "Compact and Repair" utility is designed purely to manipulate data that are stored WITHIN access.

---

Matthew Slyman M.A. (Camb.)

Answer 2

Thanks for your help! This is good to hear.

Answer 3

After I link to a MySQL backend my ACCDB file jumps from 7 to 20MB so I always have to run compact and repair. There is no adverse effects from this.

---

DanielHofer