Shared DB won't open for one user

We have a shared data base on a share folder on our server. It was recently able to be opened by many people at once. However, now it will only let one user in if everyone else is out of the file. However, all of the other users have no problems. Please advise.
cozmo_trollAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Check that your Windows permissions haven't changed for the directory housing the database ... you must have read/write/create/delete permissions for that folder.
0
 
BPebCommented:
Check out how they are opening it.  It sounds like they are opening it exclusively using the drop down ont he file open dialog.  
0
 
cozmo_trollAuthor Commented:
The user that it won't allow to open is actually me, I have tried double clicking the file or selecting open from the drop down. It acts like it is going to open (no errors), but then just doesn't.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
peter57rCommented:
Hi cozmo_troll,
So you are saying that there is no message of any kind, just nothing happens when you duble click th file?

Can you open ANY access database by double-clicking the file (try Northwind).

Pete
0
 
cozmo_trollAuthor Commented:
Pete,

Yes, there is no message. If I copy and paste this DB onto my desktop, it opens ok. And, if I open it after all other users have closed out it opens fine too.
0
 
peter57rCommented:
Examine the settiing for Default Open Mode in Tools>Options>Advanced

Pete
0
 
cozmo_trollAuthor Commented:
Pete, I am in the Tools>Options>Advanced folder, but don't see anything alarming. The Default Open Mode is set to "Shared"

LSM, how would I check the Windows permissions for that directory? I am able to read/write/create/delete anything else, and also keep in mind I can use it when no other users have access...

0
 
Jeffrey CoachmanMIS LiasonCommented:
cozmo_troll,

Is "Splitting" the database an option?
0
 
cozmo_trollAuthor Commented:
Found out nothing is wrong with the DB or permissions. Internet Explorer (the new one) was causing a security setting that wouldn't allow me to open this file. Thanks for your help.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Then as far as I'm concerned you did not have to split the points.
:)

But I'll leave that up to you.

Glad you got it working.

How did you determine that IE was the problem?
0
 
cozmo_trollAuthor Commented:
just by process of elimination... thanks for all help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.