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 problem here since when one particular user is working with the form, a second user is not able to work with the form. The entire form, then, seems to be locked as no changes are possible, not only in the record currently changed by the first user, but also the rest of them.
Any ideas of why is this happening?
Thank you very much in advance
Best regards from Barcelona
2 1257
You may do it in this way.
1. Assume you have a Database on server
2. Create a New Access and Link table to the Server Database
3. Copy the New Access to All the user
or
u can just Split your Database at tools-> Database Utilities -> Database Splitter
so u have front end program and back end database
You may do it in this way.
1. Assume you have a Database on server
2. Create a New Access and Link table to the Server Database
3. Copy the New Access to All the user
or
u can just Split your Database at tools-> Database Utilities -> Database Splitter
so u have front end program and back end database
Thank you very much for youre response. I will try to do what you state in the first place since the database splitter option is disabled in the 97 Access that we have installed here, as well as other useful options...
Best regards
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Dennis Gavrilov |
last post by:
Hi, All!
I have two questions: strategic and technical.
Technical one first:
I need to share an array of objects (implemented as hashes, having
references to other objects and hashes, sharing done after blessing)
between all of the mod_perl2 threads. The structure can grow quite big
- tenths of thousands of array elements. It can grow as system
operates (not possible to construct at apache startup). Sharing array
is OK, but inserting...
|
by: varlagas |
last post by:
We disabled the antivirus software but the problem persists. Any clues?
Many thanks in advance!
Panagiotis Varlagas
=======================================================================
2005-07-28-10.39.02.015001 Instance:DB2 Node:000
PID:1568(db2syscs.exe) TID:2440 Appid:0A00153A.C90B.050728083720
|
by: Atif Jalal |
last post by:
How can I share the sane databse connection between asp.net pages. I
also use objects(middleware), so can I pass the same DB connection
when I instantiate the object by calling its constructor?
|
by: Jeff |
last post by:
Hi -
I'm creating an installation program that will install a VB.NET program and
an instance of MSDE on an unknown desktop (commercial application). The
install will include the MSDE redistributable files (and it will launch the
MSDE Setup.exe to install MSDE).
I've read that "Except on Win 98 and Millennium, file and print sharing must
be active"
|
by: Bob Alston |
last post by:
Having problems sharing an Access database on a Windows 2000 PC. The
other PC is windows 98 (as I recall) but NOT windows 2000!
The 2nd PC has a shortcut to the MDB on the primary PC.
The MDB can be opened - 1 user at a time.
The MDB Options - Advanced -
Default open mode = shared
Open databases using record locking is checked
| |
by: pearl146 |
last post by:
Hi,
I have some database files (.MDF, .LDF,...) on the server. When I try
to delete them, the warning "Cannot delete file: There has been a
sharing violation. The source or destination file may be in use."
appears.
Since I am new to the environment I don't know where the files come
from and where they might be used.
|
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: ARC |
last post by:
Hello all,
This is really a computer sharing / network question, so sorry for posting
here; it's the only newsgroup I post in.
I have a customer with a database file on a vista machine under Users\\, who has a 2nd pc with window xp. They're getting all kinds of access
errors relating to the .mdb being read-only, etc., when they try to access
the database from the xp machine.
Using remote control, I turned on sharing for that folder...
|
by: limperger |
last post by:
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...
|
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: 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: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |