Yes, its possible.
Provided its saved on common folder/network folder Also, you will have to use ADO for updation/insertion.
How is it possible? In order to achieve this the Excel file would have to open in read only mode correct? The problem is Access open any linked Excel file in “executable” mode.
Thanks for your help.