> Hello,
>
[quoted text clipped - 8 lines]
> excel file they get 'File in Use :|' error. The person has read,
> write, modify and excute rights to the database.
Perhaps there are no rights for the second person to the Excel Spreadsheet
or to the location of the database. Generally, the least restrictive
permissions take precedence, but that depends upon how your security may be
set up.
Also, in Access, a person will have read-only rights if he does not have
delete rights to the files in the folder where the database is located. One
needs all rights to everything (with the exception of "Full Control") in
both the front-end and back-end database files.

Signature
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
DiLwALi@gmail.com - 30 May 2007 20:33 GMT