Hello everybody!
I have just found out that the sharing properties of a single database (mdb file on a network), accessed by 3 users, change depending on the user accessing the database. That is, with the file opened by 2 users at the same time, in my computer, the sharing properties appeared as set to share (not exclusive) and single entry-lock. Nevertheless, in the computer of the other user, the sharing properties are set to exclusive mode and an all-entries lock. Why, with a single file (neither splitted nor working with linked tables and different files), the Sharing mode change depending of the user? And what is worse, why the sharing properties differ even with 2 users having the database opened at the same time? Is Access trying to make a fool of us??
Best regards from Barcelona
11  3620 
Hi. I suspect that the user in question does not have Create rights to the shared directory in which the database is located. As an MS Knowledgebase article linked here states, if the shared .ldb lock file cannot be created the database will be opened in exclusive mode by that user.
The user rights required for each user of an Access database placed in a shared directory are Read, Write, Edit, Create and Delete.
-Stewart
Hi again. I have now closed the previous thread which you started on this topic on 3 April. It is not good practice to create duplicate threads if you don't get a reply to your first post. All you need to do is to 'bump' the topic by posting a reply to your own question asking if a contributor could look again at your issue.
-Stewart
Hi Stewart:
First and foremost: let me apologise for any inconveniences caused by this second post. I wrote it again so as to provide new information.
Second, I don't know if what you're commenting is de tools>security> group and users permission. Is that it?
Thank you in advance
Best regards
...Second, I don't know if what you're commenting is de tools>security> group and users permission. Is that it?...
Hi limperger. No worries on the second post - if you are faced with a similar situation in future just add the new data as a new message in the original thread.
What I am referring to is not the Access security tools; it is the network folder permissions granted to the user who is locking the database. This is nothing at all to do with Access; the permissions are granted by whoever administers your network when their accounts are created. As mentioned, a user must have create access rights to the shared folder in order for Access to create its .ldb lock file.
-Stewart
To the best of my knowledge, the network setting grants every user an administrator status, so as to be able to do every action required.
But even more incredible now.... I have just tested, with the user having this problem (and with his account), the database sharing performance and I have been able to open the file after he has opened it in the first place. This situation suggests me that the real problem has to do with the computers used (this particular user uses 3 different computers to access the database), rather than the network setting (which, I repeat, should be set as "administra tor status" by default). Am I right? Any wonder why is this happening?
Best regards from Barcelona
New information coming!!!
Surprisingly, now that this user has typed some data into the database (using a form), I am not able to open the file. That is, in the previous situation, I have opened the file with his account and I have been able to do the same with mine. But no data has been typed. But soon afterwards, after hearing him typing some data into the data base, I have tried to open the file again and, to my surprise, I have not been able to. I have checked the sharing properties (in case in his Access session might had spontaneosly changed), and remain as specified (shared and edited-record lock). Please note here that there is no front-back end database splitting.
This situation is wearing me down!!
Best regards
Hi. Make sure that everyone else is logged off from the database then log your user with the lock problems in to your database. If he has the correct permissions you will see a file called <yourdatabase>. ldb in the same folder as the database, with time of creation the time at which your user logged in.
If you do not see such a file there is a permissions issue, regardless of what you are telling me about his administrator status. Could you check this please
The .ldb file is updated for each new user who logs in, and is automatically deleted when the last user logs out
As mentioned, no ldb file equals no shared access.
I have attached a small screenshot from one of my shared databases called Staff which shows the Staff.ldb lock file, so you can see what to look for in your shared folder.
-Stewart
Stewart:
I confirm you that a ldb file appears everytime any of the users log on the database. And another aspect of interest: this problem seems not to appear between me and the other user (not the one with this problem), that is, I am able to log on irrespective of he typing data on the database or he accessing the database in the first place.
Best regards
Sorry, limperger, there is no more I can suggest at present. If your user can create an LDB file, and the network rights are the same as everybody else, and there are no specific security settings which have been changed, I am out of ideas as to why there should be any differences in record locks for one specific user, or why you should be able to access and update the DB at all times when others cannot.
Perhaps other contributors may be able to help
-Stewart
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Dixie |
last post by:
Can I set the Format property in a date/time field in code?
Can I set the Input Mask in a date/time field in code?
Can I set the Format of a Yes/No field to Checkbox in code?
I am working on a remote update of tables and fields and can't find enough
information on these things.
Also, how do you index a field in code?
|
by: JoeS |
last post by:
Is there anyway to share a single pch file between
projects in VC 7.0? I have 300+ projects each of which
creates its own pch. All projects include the exact same
header files in the precompiled header. Its takes about 7
seconds to create the precompiled header for each project.
That's 35 minutes spent creating precompiled headers for
all project! All of the projects use PDB files for debug
info.
I tried creating Precomp.pch in project...
|
by: BPearson |
last post by:
Hello
I would like to have several sites share a single web.config file. To accomplish this, I would point the root of these sites to the same folder. Is there any reason why I might not want to do this? (IIS 5 or 6
In case you're wondering why I would do this, we have many web sites on a single server, and there are groups of sites that need to share common configuration information. I'd like to ease some administration by having one...
|
by: qube3 |
last post by:
We have applications written by JSP/Servlet and ASP.NET. All our future
development would be based on ASP.NET.
We wants to develop a single user interface so that users would not be aware
that some of the modules they are using are implement by JSP or ASP.NET
(e.g. no need to login both JSP and ASP.NET applications)? Are there any
suggestions to share the session in formation among JSP and ASP.NET, or some
single-sign on solution.
|
by: Nick |
last post by:
Hello,
Please pardon my ignorance as this is something I should know, but I'm a
little unclear. I have an MDI based app. It is setup so the user opens a file
and the main child form is created. Once that is opened one (or more)
properties forms can be opened. What is the best method for sharing data
between the properties forms and the main child form? I need to alert the
main child form when a value is modified in a properties form so I...
| | |
by: Max Vit |
last post by:
I have deployed few Access apps splitting it in Front End and Back
End. Our environment uses Win XP SP2 for clients, Win 2k3 for servers
and Access 2003. The max. number of clients is about 50 (concurrent
users is estimated around 10).
Whilst the Back End always lives on a server, I am not quite clear
where the Front End should live.
I have searched the web and find contradicting views.
|
by: Jonathan Wood |
last post by:
Greetings,
I'd like to write any number of classes and then use those classes from any
number of .NET applications.
Since we've supposedly left "DLL Hell" and ActiveX objects behind, what has
taken it's place.
Can anyone point me in the right direction getting started learning the best
way to write a library of routines and then being able to access those
|
by: Peri |
last post by:
Dear All,
Is there a way in which 2 application can share a common memory location to
access static data?
Say for example I have a product master data that is available in a single
place, and I have an application that uses this data to do its own
operation. I also have a similar kind of another application that uses the
same data for its another operation. Can we implement this in C#?
|
by: limperger |
last post by:
Hello everybody:
At my workplace, there is a Access database that is shared between 3 users. We are currently experiencing some problems with the sharing. Let me explain it: I have set the sharing properties (at tools>options) as Database status = Shared (not exclusive) and entry-locked, as well the other lock at record-level. Additionally, I have set an entry lock (record level) in the form properties. Nevertheless, we have a bit of a...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
