I have an Excel file that is linked in Access.
Access then has a query built on this linked table.
I have another Excel file (a pivot table) that is linked to the Access
query that multiple users can open to view details of the query, with
the ability to drill down to the record level.

However, I can not overwrite Excel file 1 if users have Excel file 2
open. Are there security options I can change somewhere to get this to
work? I tried to change the permissions to only allow write access to
the database for Admin (myself), but it still doesn't work if the Excel
file is open as it is locking the table.

I am hoping a complete re-work of this is not needed.

Any help is appreciated.


--
nukeawhale
------------------------------------------------------------------------
nukeawhale's Profile: http://www.excelforum.com/member.php...o&userid=30683
View this thread: http://www.excelforum.com/showthread...hreadid=503449