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,