File in Use Error

[DiLwALi]

Hello,

I have a excel spreadsheet with two worksheets, each of which connects
to the same Access database via an ODBC connection to retrieve data.
The worksheets have different data and are pulling from different
tables in access. I was able to do this without any problem but since
I am the owner and creator for both files I did not forsee any
problems.

Now I need another individual to do this task but when they open the
excel file they get 'File in Use :|' error. The person has read,
write, modify and excute rights to the database.

Any help will be appreciated. Thank you.

Sini

 

[Arvin Meyer [MVP]]

Hello,

I have a excel spreadsheet with two worksheets, each of which connects
to the same Access database via an ODBC connection to retrieve data.
The worksheets have different data and are pulling from different
tables in access. I was able to do this without any problem but since
I am the owner and creator for both files I did not forsee any
problems.

Now I need another individual to do this task but when they open the
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.

 

[DiLwALi]

Thank You ! It worked