Hi,
I have a problem with a multi-user db in Access 2000.
The db is for logging calls to my company and will be used by up to 30 people, though currently around 10 are using it.
I have split the db into front/back end and each user is using a local copy of the front end, connected to the back end via our network.
It was all working fine when we tested it (across 2 different sites) and had no problems, but now, some new users are using it and I keep getting a problem where they cannot save/update a record and get the message "cannot update - currently locked" - this then means that all users start to experience the sameproblem. If everyone logs out it solves the problem.
Default Open Mode = shared
Default Record Locking = No locks
Open databases using record-level locking = true
Please can someone help with this - I'm not sure why this is happening and need to sort it out quickly.
Many thanks,
11 3492
can anyone help with this?
Have I phrased my question badly or is it just that no-one knows why I could be having this problem? Some sort of response would be greatly appreciated.
Many thanks,
Olly
Have I phrased my question badly or is it just that no-one knows why I could be having this problem? Some sort of response would be greatly appreciated.
Many thanks,
Olly
Such impatience, Olly - generally, no response means we don't know either!
-Stewart
Thanks for replying Stewart
I'm really stuck now! :)
Hi again Olly. Did your lock difficulties begin when the new users started using the DB? As Access creates an LDB share file while users are accessing the DB I wonder if there is a network issue with the new users, perhaps momentary disconnections which leave the LDB file in an unknown state until everybody logs out? Just guessing, really, as it does not appear to be an Access issue. Could be anything, network card, switch, router or whatever.
Not much help, I know, but you appear to be doing everything right with Access itself...
-Stewart
Just as an added thought, have you done a decompile on the production version of your database? You could potentially be experiencing corruption introduced from a variety of different sources, however, the most likely is that during the development process of writing code, compiling, saving and testing, the code goes through a number of different states of compilation.
Try this working on a COPY of your database: call up the command window (start menu, Run) and type in something like this: - "c:\Program Files\Microsoft office\office\msaccess.exe" /decompile "c:\My Documents\MyDatabase.mdb"
The first file path refers to where your local version of Access is stored on your computer. The second file path refers to where your copy of the particular database .mdb file is located on your computer.
Regards,
Scott
I should mention that you should do a Compact-Repair both before and after you do the decompile.
Regards,
Scott
Thanks Scott/Stewart,
Stewart - yes it was when new users started using it that the problem occurred. I'm not aure about problems with the network however as we successfully share several other dbs in the same way.
Scott, I've tried what you suggested (compact/repair, decompile, compact/repair) - should anything have visibly "happened" during decompile? I ceratinly didn't see anything, the database simply seemed to open.
Many thanks for your help,]
Olly
I should have mentioned that the database needs to be closed during while executing the decompile command.
The main thing you should notice is a decrease in size of the mdb file. In many cases it will lose about 50% of its size... i.e. a 4mb database will become 2mb.
You should also notice a significant increase in speed of opening (if it's been slow opening before...)
Regards,
Scott
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Grandpa Pete |
last post by:
How can I share resources across all users of a web service for read/write
access.
*Situation* *one*:
I want to have an in memory counter that all users of the webservice could
access. Call it g_count.
Then I create a web method called Update_g_count.
|
by: Mike Wiseley |
last post by:
We recently converted our department wide shared Access97 database to
Access2K. We used to be able to open various reports in design mode and make
changes to the design (or create new reports) even while other users in this
shared database might be using other, unrelated reports.
Now, in Access2k, it appears that whenever you do not have exclusive access,
you cannot make any design changes to reports. It seems that the presence
of any...
|
by: Inquest750 |
last post by:
Can anyone tell me where I can get instructions to design an Access
database to work directly with a website? The website will hopefully
contain a member base and that is what i would use access for. The
databases purpose is to collect all the information that i would
require for new members to enter upon registration... The database
would also need to be connected to to verify users logging in of
correct usernames and passwords....has...
|
by: Wayne Aprato |
last post by:
I have a simple database which was originally written in Access 97.
When converted to Access 2000 file format it ran flawlessly in Access
2002. I've just tried to run it in Access 2003 and I am seeing the
following behaviour:
Some of the fields on the continuous main form which is a list of jobs
with their related details "flicker". While this is going on the form
seems to function as it should and isn't locked up. If I click and
hold...
|
by: M. David Johnson |
last post by:
I cannot get my OleDbDataAdapter to update my database
table from my local dataset table. The Knowledge Base
doesn't seem to help - see item 10 below.
I have a Microsoft Access 2000 database which indexes
computer magazine articles for personal reference.
I am developing a Visual Basic.NET program whose sole
purpose is to enter new records into the database. No
updates to existing entries, no deletions, and no display
| |
by: hkappleorange |
last post by:
I ued this code to connect to a mdb file
A = New OleDbConnection( "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA
Source=C:\Inetpub\wwwroot\ASPX\Authors.mdb" )
|
by: jt |
last post by:
The program works like this:
There is a form with a button.
When the form is loaded, a separate thread is started which is
retreiving/updating data in the database every x seconds.
When clicked on the button, data is retrieved from the database.
This looks to work fine. However, sometimes after clicking on the butten to
retrieve the data i got an error message (on the separate thread):
"The connection is already Open"
|
by: amindi |
last post by:
Hi,
I wrote a VB6 program to read some data records from a Ms Access database and to write them into a SQL server database.(I use Ms Access 2000 and SQL server 2000).After reading each record in Access database, I update a text type datafield of that record in Access database to 'Y' (to mark the perticular record as a copied record)(The program does the updation). I tested the program several times by using a seperate copy of the same database...
|
by: chaseexchange |
last post by:
First, a brief explanation of why this has happened. I purchased, what
I thought, was a fully functional program written in Access last year
from a local programmer. This program was to be used as my POS for an
online DVD store. It turns out that what the programmer actually gave
me was a "license" to use his software. This was not the agreement we
made, and he knows this. He took advantage of the fact that I knew
very little about...
|
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: 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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |