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
Apr 4 '08
11 3621
Hello Stewart:
First and foremost: Thank you for your help. It is much appreciated indeed!
Secondly, let me sum up the situation, so as to get the picture clear.
1) As confirmed by the computer ' technicians here, everybody is granted an administrator status in the network. So if, as you confirmed, the permission setting you were talking about has nothing to do with Access itself, then the problem should not be due to the network account.
2) I checked the Access file, once locked its access for the rest of us, opened by the user with this problem. The Tools>Options>A dvanced were as specified: shared status and edited-record lock. Also, the form properties were set as edited-record lock. In short, no changes in here.
3) Could there be any changes in the ldb file, as the session progresses? I mean, is it possible for the ldb to experience any change in its properties? Maybe, if this should be the case (I have no idea), I could check its properties and shed some light on the problem. Anyway, what is clear is that the ldb appears for all users.
4) There is no FE-BE split. I would try to do it and see if there is any improvement. Could the FE-BE division help in here?
Thank you very much in advance
Best regards
Hello everyone!
With the splitting of the database, the sharing problems are over. DB splitting is, therefore, strongly recommended for everyone!
Best regards
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
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...
| |