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 / Multiuser / Networking / February 2006

Tip: Looking for answers? Try searching our database.

Periodic "no exclusive access..." message

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carl Rapson - 16 Feb 2006 16:18 GMT
I have a split database (FE on users' systems, BE on server) that
occasionally, for no reason I can discern, gives a user the old "You do not
have exclusive access..." message upon opening the database. I'm not using
Access security, so I know the problem isn't related to a workgroup file.
The problem doesn't happen consistently (that I've been able to tell), and
it doesn't always happen to the same user. All users have full access rights
to the server folder where the BE is stored. So far, when the message has
appeared, the user can click through it until the database opens, and then
everything works fine - including updates to the database (despite what the
message says).

Can anyone suggest some other reasons that this message would occur on an
infrequent basis? And why it would appear but then allow the users to make
changes anyway? Any insights would be greatly appreciated.

Carl Rapson
Tony Toews - 16 Feb 2006 18:15 GMT
>I have a split database (FE on users' systems, BE on server) that
>occasionally, for no reason I can discern, gives a user the old "You do not
[quoted text clipped - 9 lines]
>Can anyone suggest some other reasons that this message would occur on an
>infrequent basis?

One reason may be that one particular use doesn't have full
read/write/delete privileges to that folder thus the user can't create
the .ldb file.   Now if they are the only one in then they don't
notice anything and are given an exclusive lock to the MDB.  But the
next person in get's the above mentioned message because they can't
get a shared lock on the MDB.

You can test this by getting the users to create a notepad .txt file
on the share and deleting if.  If that is successful then they are't
the problem.

>And why it would appear but then allow the users to make
>changes anyway?

Now that doesn't make any sense at all.

Tony
Signature

Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Carl Rapson - 17 Feb 2006 21:48 GMT
Tony,

Thanks for the response. I'm pretty sure all users have full
read/write/delete access to the server folder, but based on your comments I
will double-check that.

Carl

>>I have a split database (FE on users' systems, BE on server) that
>>occasionally, for no reason I can discern, gives a user the old "You do
[quoted text clipped - 30 lines]
>
> Tony
 
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.