Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / May 2007

Tip: Looking for answers? Try searching our database.

File in Use Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DiLwALi@gmail.com - 29 May 2007 13:52 GMT
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] - 29 May 2007 15:45 GMT
> 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
Thank You ! It worked
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.