Re: Back end database lock-up
- From: "Tony Toews [MVP]" <ttoews@xxxxxxxxxxxxxxx>
- Date: Tue, 18 Nov 2008 20:13:40 GMT
Sam Lambson <samlambson@xxxxxxxxx> wrote:
Alright. The problem, it turns out is not the form, nor the query,
nor the linked tables. I think it might be my environment. My shared
backend reside on a network drive that is found on a UNIX system. I
checked teh permissions for the folder, and in the main settings
nothing is clicked but "Special" and when I go to Advanced, it has the
groups "Everone" "Me" and "The Group that employees belong to" and
gives "Full control" to me and the group of employees and grants
nothing to everyone.
The reason I think it might be permissions is that the entire backend
locks up anytime a open a linked table, query, or form on the front
end. It locks the entire backend as if it was open exclusively,
granting read-only to anyone trying to access it.
Is it my environment or something else?
That is quite possible. I know next to nothing about *nix networking. However
Microsoft Access does "interesting" things with locking. Now this may only apply to
Jet locking of records and not to locking the complete file. Also older versions of
Samba, the *nix module which handles Microsoft compatible networking, had problems
years ago with exactly duplicating ill documented MS networking features. But I
thnik those should've been long fixed. Maybe.
The problem is that MS uses "phantom locks" in a non standard method. So it may work
well and may not. The following discussion is in reference to Samba. Note that
Novell does handle Access well. Well, except for some versions and the OpLocks
problem.
Samba, the Unix component which provides Windows networking services, has been
written to the documented specs and yet sometimes doesn't work well. For many people
this has worked quite well but others have had lots of troubles.
ACC2000: Microsoft Access and Untested Networks - 209161
http://support.microsoft.com/?kbid=209161
I think ACC: Microsoft Jet Utilities Available [Q176670]
http://support.microsoft.com/?kbid=176670 has some detailed info on "phantom locks"
in the "Understanding Microsoft Jet Locking" whitepaper,
There is an introduction on SAMBA at http://us1.samba.org/samba/docs/SambaIntro.html.
It info on mapping Windows drives to Linux directories.
Someone stated somewhere, somewhen:
-Use Samba >2.2.7 and copy the backend to this share
-Read/write-permisssion for the users
-Install the frontend on every pc an connect the tables
-Read the doc readme2k.txt in the samba-share of the linux-box
Tony
--
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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.
- References:
- Re: Back end database lock-up
- From: David W. Fenton
- Re: Back end database lock-up
- From: Rich P
- Re: Back end database lock-up
- From: Sam Lambson
- Re: Back end database lock-up
- Prev by Date: Re: Access 07: My query is making the back end database lock up
- Next by Date: Re: Back end database lock-up
- Previous by thread: Re: Back end database lock-up
- Next by thread: Re: Back end database lock-up
- Index(es):
Relevant Pages
|
Loading
