473,509 Members | 8,693 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Windows 2000 Server and Access 2000 constant corruption

The company I work for has been running Access 2000 on a Windows NT
server with Opportunistic Locking turned off on the server without
issue for almost a year. We have just switched to a Windows 2000 file
server with service pack 3 installed and are now experiencing at least
2 corruption's a day. The registry setting for Opportunistic Locking
that was on the Windows NT server does not exist on the Windows 2000
server so we can not make the needed change to the new server. From
what I understand service pack 3 is supposed to take care of this
problem. Does anyone have any suggestions on how to proceed? Any help
would be appreciated as this has caused a very unstable work
environment.
Regards,
Mark C.
Nov 12 '05 #1
1 1569
While I am not an infrastructure person, I am almost certain that you can,
indeed, turn of OpLocks in W2000 Server -- but it wouldn't surprise me that
it is in a different place in the menu structure.

The best collection of links and information on the subject is at MVP Tony
Toews' site, http://www.granite.ab.ca/accsmstr.htm. If the details of
turning off OpLocks aren't there, it's very likely there's a hyperlink to
another source where you can find the details.

Larry Linson
Microsoft Access MVP

"Mark" <he******@yahoo.com> wrote in message
news:cb********************@comcast.com...
The company I work for has been running Access 2000 on a Windows NT
server with Opportunistic Locking turned off on the server without
issue for almost a year. We have just switched to a Windows 2000 file
server with service pack 3 installed and are now experiencing at least
2 corruption's a day. The registry setting for Opportunistic Locking
that was on the Windows NT server does not exist on the Windows 2000
server so we can not make the needed change to the new server. From
what I understand service pack 3 is supposed to take care of this
problem. Does anyone have any suggestions on how to proceed? Any help
would be appreciated as this has caused a very unstable work
environment.
Regards,
Mark C.

Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
15207
by: Ken Lindner | last post by:
I have a need to become familiar with SQL Server 2000 for work. Needless to say I am new to SQL Server any version, but not IT in general. My employer has provided me with the SQL Server 2000...
28
6538
by: deko | last post by:
After doing a lot of vba work, I've noticed the size of my mdb has grown, even though no data or objects have been added. I've read that the following procedure will remedy this and improve...
19
2699
by: Mark C. | last post by:
The company I work for has been running Access 2000 on a Windows NT server with Opportunistic Locking turned off on the server without issue for almost a year. We have just switched to a Windows...
8
2060
by: William Bradley | last post by:
First of all I have been working with Access 97 and this morning the owner of the business phoned me to inform me that he had updated to Access 2000 and parts of my forms would not work anymore. ...
7
1897
by: Doug Vogel | last post by:
Hi All - I have a client for whom I developed an Access 2000 database. The database is split into 2 files - front-end (forms, queries, reports), and back-end (tables). An .mde file has been...
11
2241
by: stu | last post by:
I have several databases that are opened using various versions of Access and VB. Up till recently everything worked fine, then I started getting a variety of lock file error messages, both on my...
47
4482
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small...
34
2536
by: Mathieu Trentesaux | last post by:
Hello I downloaded Office 2007 for this reason : It seems, once again, that it is impossible to save any modification done in a VBA library, from the main project in Access. The save button...
13
2650
by: Owen Jenkins | last post by:
Following on from an earlier post... I can reliably corrupt a record by doing the following ... Open two separate but identical front ends on one PC each linking to the same back end. Edit a...
0
7237
marktang
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,...
0
7137
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...
0
7347
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,...
0
7416
jinu1996
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...
0
4732
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...
0
3207
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1571
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 ...
1
779
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
443
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...

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.