?
Solved

Windows 98 and Access 2000 performance issue

Posted on 2004-11-18
9
Medium Priority
?
348 Views
Last Modified: 2008-03-04
I have a very small access 2000 database with approximately 14 people accessing it.  They are all on Windows 98 machines and the performance is slow at best.   I have one guy here who assumes throwing memory at the pc's will fix this issue.  I am not buying that just yet.  I know the way Access works.  Copying the specific table back to the client every time it's accessed.  Will upgrading memory from 128 to 256 help this problem?  Or is that just throwing good money after bad?  I'm on a 10/100 network and all other apps seem to work great.
0
Comment
Question by:dboyer6156
  • 5
  • 2
7 Comments
 
LVL 2

Expert Comment

by:myron-szy
ID: 12615811
Are you operating on a domain or on a peer-to-peer network?
Is the Access 2000 database stored on one computer?

Opportunistic locking can play havoc with shared databased and in this case it's urgent that you turn opportunistic locking as soon as possible, as a fail-safe precaution.

See several articles for several different database products:
 http://www.google.co.uk/search?hl=en&q=%2B%22oplocks%22+%2B%22windows+98%22&meta=

Also see an article on EE:
 http://www.experts-exchange.com/Databases/MS_Access/Q_21129733.html
0
 
LVL 2

Expert Comment

by:myron-szy
ID: 12615845
My typing needs to improve:  As in . . . "turn off opportunistick locking" . . .
0
 
LVL 2

Expert Comment

by:myron-szy
ID: 12615890
Oh, increasing RAM from 128Mb to 256Mb will always help.  Especially for a database like Access 2000.  Try it with one workstation.  If it works, may be worth upgrading all the others.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 

Author Comment

by:dboyer6156
ID: 12617954
It's on a domain network.   I went ahead and upgraded the pc's to 512.   How do I go about turning off opportunistic locking?  I had an issue today someone decided to get happy and log in as admin on one of the machines then used the software to access the database and it locked it out.  Is this what opportunistic locking does?  Sorry if I sound a little un-educated but access has never been my thing.
0
 

Author Comment

by:dboyer6156
ID: 12617963
forget my last post I followed your links..  thank you for the help.
0
 
LVL 2

Accepted Solution

by:
myron-szy earned 2000 total points
ID: 12620840
Opportunistic locking is where a part of the file needs to be locked.  Locked as in one process can alter it but the others can only read, or have no access.  The `opportunistic` bit is once a file or record is locked, the oprtating system assumes the the process will access some more of the file after the part is locked so read a little bit more into memory, regardless if the process that's locked the record will use the pre-fetched data or not.

Now, what if another process on another does not operate properly on a network that uses opportunistic locking?  Ouch...  Without going into details, this results in corrupted databases.

Now, you mention that you're using a domain and I assume the shared data also resided on the domain controller.  In this case, with your network not being large hence losing a little performance (you won't even notice the difference) you can disable opportunistic locking on the domain controller, which means you need to do nothing on the workstations.  As in the workstation may ask for opportunistic locking, but the server will always deny the request.

See:
 http://support.microsoft.com/default.aspx?scid=kb;en-us;296264

Quoted from the article:
 You can also deny the granting of opportunistic locks by setting the following registry entry to 0:
 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
 EnableOplocks REG_DWORD 0 or 1
 Default: 1 (Enabled by Default)
 NOTE: The EnableOplocks value configures Windows-based servers (including Workstations sharing files) to allow or deny opportunistic locks on local files.

As always, make a note of all settings and perform a system state backup on the domain controller before messing with the registry.  Also, be sure you know how to edit the registry.

I did this on our network, cured many problems.  Just recently disabled OpLocks on adomain controller on another network and since that's been done, the Lotus Approach databases became stable, especially when more than one person was working on the same data.

Have a search for `OpLocks` and `Opportunistic locking` on Google and Microsoft's knowledgebase.  You'll see many comments, especially on the Google search and just about all of them is how to turn OpLocks off.

It it does work, please do post a comment.

Upgrading the PC's to 512Mb will do no harm.  Actually, does more good.  You'll find out that you will NOT need to throw more memory at the problem.  Any other slowdowns may be network related.

Please do tell if any of the advice given is useful, or not.
0
 
LVL 2

Expert Comment

by:myron-szy
ID: 13118016
I like points.  [=:  Thanks.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Tech spooks aren't just for those who are tech savvy, it also happens to those of us running a business. Check out the top tech spooks for business owners.
How to fix a SonicWall Gateway Anti-Virus firewall blocking automatic updates to apps like Windows, Adobe, Symantec, etc.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question