troubleshooting Question

Access - can't save objects, says I need exclusive rights to the file

Avatar of kim campion
kim campion asked on
Microsoft Access
5 Comments4 Solutions85 ViewsLast Modified:
I have a client I'm helping with a database.  There are about 12 people who use this file.  The file is split into front end and back end.  All employees access the same front end.  They are trying to create a new query or report, but are given the error message "Microsoft Office Access can't save design changes or save to a new database object because another user has the file open.  To save your design changes or to save to a new object, you must have exclusive access to the file".  

Nobody is opening the file with exclusive rights, and to create a simple query, they don't need this.  Any help is appreciated.  Thanks!
Join our community to see this answer!
Unlock 4 Answers and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros