473,836 Members | 1,557 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Shared database locked - cannot update - Access 2000 - Help!

ollyb303
74 New Member
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,
Mar 5 '08 #1
11 3498
ollyb303
74 New Member
can anyone help with this?
Mar 7 '08 #2
ollyb303
74 New Member
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
Mar 12 '08 #3
Stewart Ross
2,545 Recognized Expert Moderator Specialist
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
Mar 12 '08 #4
ollyb303
74 New Member
Thanks for replying Stewart

I'm really stuck now! :)
Mar 12 '08 #5
Stewart Ross
2,545 Recognized Expert Moderator Specialist
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
Mar 12 '08 #6
Scott Price
1,384 Recognized Expert Top Contributor
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:

Expand|Select|Wrap|Line Numbers
  1. "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
Mar 12 '08 #7
Scott Price
1,384 Recognized Expert Top Contributor
I should mention that you should do a Compact-Repair both before and after you do the decompile.

Regards,
Scott
Mar 12 '08 #8
ollyb303
74 New Member
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
Mar 13 '08 #9
Scott Price
1,384 Recognized Expert Top Contributor
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
Mar 13 '08 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

6
547
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.
6
4261
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...
5
1639
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...
4
2144
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...
0
5831
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
4
2767
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" )
10
4584
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"
1
7954
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...
15
4120
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...
0
9673
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,...
0
10859
Oralloy
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...
1
10602
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,...
0
10260
tracyyun
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...
0
9388
agi2029
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...
1
7795
isladogs
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...
0
5829
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4463
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
3
3116
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.