In Access 2010, how to make linked excel table accessible while it's being ediited?
Posted on 2010-08-18
I have an Access 2010 database with a linked Excel spreadsheet as a table. Everything works fine until someone opens the spreadsheet to edit it, then I get message stating ".... already opened exclusively by another user...". Is there a way to open the spreadsheet linked table in Access as "read only" while it's being edited in Excel?
This works if you try to open a 2nd instance in Excel, it just asks if you want to view as "read only", why doesn't Access work similarly?
Thanks for your help,