Access 2007 Locking Issue - Attachments being overwritten

We're currently running into an issue with an Access 2007 database for a client. They've got Excel 2007 documents attached to records within the database. Whenever changes to the document are made, they are overwriting each other, and we're not sure exactly why. This is happening with different records, and all of the attached documents are named differently. We'v开发者_如何转开发e tried adjusting the different locking schemes, but this doesn't seem to resolve the issue.

Any ideas? Are we missing something?

---

the attached documents are overwriting other attached documents the key is they are open at the same time by different users.

They are making the changes using excel saving them to a temp folder and then access saves the documents through its interface. This is pretty standard.

@dvhh Please refrain from access bashing. I agree access sucks. This is a system the client already had in place that I need to get working or give a reasonable response to why this particular piece is not working and can not be fixed.

@Remou access is limited there are better options out their Access has its place and its uses for business please leave it at that.