Originally Posted by
Fostertrident
Thanks this has made things better, no more crashing, but now I'm getting this error
The Microsoft Office Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.
this is because a colleague is using a linked table. the only way for me to get it to work is open up the linked spreadhseet myself as read-only.
Is there any way of preventing this? and allowing users to open the linked table and for Access to be okay with that?