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 corruptions 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 procced? Any help
would be appreciated as this has caused a very unstable work
environment.
Regards,
Mark C. 19 2698 he******@yahoo.com (Mark C.) wrote: 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 corruptions 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.
Add the registry setting as per the KB article Configuring Opportunistic Locking in
Windows http://support.microsoft.com/?kbid=296264 and reboot.
From what I understand service pack 3 is supposed to take care of this problem.
But Win 2000 SP3 must also be installed on all the client systems as well.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony,
Thanks for your help but the changes you mentioned did not help.
The registry setting was added on the server side and all the client
machines already have service pack 3. We had a total of 5 corruption's today
in 2 different databases.
We had a rep. from Microsoft on the phone today and he thinks that it is not
Ops Locks that is the problem. He told us that the MSJET DLL that we are
using is old but this is the same DLL we used in the Win NT server
environment with no corruption's. We made the change this evening with the
DLL and just have to pray that it works. Microsoft told us to try this
first and if it does not work to call them back. Do you think they know what
they are talking about? If anyone has any insight to this type of problem
please by all means help us out. I guess if all else fails we can go back to
the Win NT server were we had no corruption's but eventually we have to
upgrade.
Regards,
Mark
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:44********************************@4ax.com... he******@yahoo.com (Mark C.) wrote:
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 corruptions 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. Add the registry setting as per the KB article Configuring Opportunistic
Locking in Windows http://support.microsoft.com/?kbid=296264 and reboot.
From what I understand service pack 3 is supposed to take care of this problem.
But Win 2000 SP3 must also be installed on all the client systems as well.
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm he******@yahoo.com (Mark) wrote in
<ZO********************@comcast.com>: The registry setting was added on the server side and all the client machines already have service pack 3. We had a total of 5 corruption's today in 2 different databases.
We had a rep. from Microsoft on the phone today and he thinks that it is not Ops Locks that is the problem. He told us that the MSJET DLL that we are using is old but this is the same DLL we used in the Win NT server environment with no corruption's. We made the change this evening with the DLL and just have to pray that it works. Microsoft told us to try this first and if it does not work to call them back. Do you think they know what they are talking about? If anyone has any insight to this type of problem please by all means help us out. I guess if all else fails we can go back to the Win NT server were we had no corruption's but eventually we have to upgrade.
Are the Access installations at least SR1a+ and at least Jet
4 Service Pack 6? If not, you'll continue to experience corruption.
Once you have that in place in 100% of workstations (even one out
of 100 will cause corruption), the you can start looking at other
sources of problems.
I've been through this dozens of times -- SR1a or later plus Jet 4
SP6 is the minimum safe installation of Access 2000. Anything less
is going to cause corruption eventually.
And don't just guess -- check every single workstation. At my
largest installation (about 40 workstations) I put in code that
logs Access version and Jet version in a central table when the
users log in so I can always check who is running what version of
Access (and, yes, workstations revert when they are rebuilt by
techs who don't know what they need to do to fully re-install
Access).
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
On Mon, 22 Dec 2003 21:40:48 -0800, "Mark" <he******@yahoo.com> wrote:
It's a very good idea to be current on Jet service packs. Jet4SP8 is
the latest version.
-Tom. Tony,
Thanks for your help but the changes you mentioned did not help.
The registry setting was added on the server side and all the client machines already have service pack 3. We had a total of 5 corruption's today in 2 different databases.
We had a rep. from Microsoft on the phone today and he thinks that it is not Ops Locks that is the problem. He told us that the MSJET DLL that we are using is old but this is the same DLL we used in the Win NT server environment with no corruption's. We made the change this evening with the DLL and just have to pray that it works. Microsoft told us to try this first and if it does not work to call them back. Do you think they know what they are talking about? If anyone has any insight to this type of problem please by all means help us out. I guess if all else fails we can go back to the Win NT server were we had no corruption's but eventually we have to upgrade.
Regards, Mark
"Tony Toews" <tt****@telusplanet.net> wrote in message news:44********************************@4ax.com.. . he******@yahoo.com (Mark C.) wrote:
>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 corruptions 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.
Add the registry setting as per the KB article Configuring Opportunistic Locking in Windows http://support.microsoft.com/?kbid=296264 and reboot.
>From >what I understand service pack 3 is supposed to take care of this >problem.
But Win 2000 SP3 must also be installed on all the client systems as well.
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"David W. Fenton" And don't just guess -- check every single workstation. At my largest installation (about 40 workstations)
40 workstations .... with linked tables to SQL Server?
Bye: Red xx**@usa.net (Red) wrote in
<SI*********************@twister2.libero.it>: "David W. Fenton"
And don't just guess -- check every single workstation. At my largest installation (about 40 workstations)
40 workstations .... with linked tables to SQL Server?
No, to an MDB. 25 or so of the users are read-only. Of the
remainder, only 6 or so of them ever edit more than one table. Of
the remainder, the editing is very sporadic, mostly adding records,
not editing. The actual user load at any particular time is
substantially lower than the number of workstations would imply.
In any event, that app has version checking because it's just too
easy for the workstations to get rebuilt/replaced and no longer
have the proper version of Access/Jet.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
"Mark" <he******@yahoo.com> wrote:
(Sorry for the delay. ISP not processing outbound messages for a few days.) Thanks for your help but the changes you mentioned did not help.
The registry setting was added on the server side and all the client machines already have service pack 3. We had a total of 5 corruption's today in 2 different databases.
Interesting. The OpLocks setting is definitely the first thing to check with a new
server.
We had a rep. from Microsoft on the phone today and he thinks that it is not Ops Locks that is the problem. He told us that the MSJET DLL that we are using is old but this is the same DLL we used in the Win NT server environment with no corruption's. We made the change this evening with the DLL and just have to pray that it works. Microsoft told us to try this first and if it does not work to call them back. Do you think they know what they are talking about? If anyone has any insight to this type of problem please by all means help us out. I guess if all else fails we can go back to the Win NT server were we had no corruption's but eventually we have to upgrade.
What MSJet DLL and where does it reside? Presumably on all the client systems. And
not on the server. There is no need to install any Jet DLLs on the server as
Access running on the client workstations wouldn't use them.
Have you folks split the databases into a FE/BE with each user getting their own copy
of the FE?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm dX********@bway.net.invalid (David W. Fenton) wrote: Are the Access installations at least SR1a+ and at least Jet 4 Service Pack 6? If not, you'll continue to experience corruption. Once you have that in place in 100% of workstations (even one out of 100 will cause corruption), the you can start looking at other sources of problems.
Agreed that one workstation with a different Jet SP level can cause corruptions.
And don't just guess -- check every single workstation.
I know David knows this but I thought I'd add the following which has a link to code
for the benefit of the original poster and the lurkers.
What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the tips page at my website for more details including sample
code: Verify Appropriate Jet Service Pack is installed www.granite.ab.ca\access\verifyjetsp.htm
I should likely be a bit more redundant and check every file distributed by the Jet
SP.
At my largest installation (about 40 workstations) I put in code that logs Access version and Jet version in a central table when the users log in so I can always check who is running what version of Access (and, yes, workstations revert when they are rebuilt by techs who don't know what they need to do to fully re-install Access).
Absolutely agreed. This is now standard practice for me whenever I do something new
or renovate an already existing app.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm dX********@bway.net.invalid (David W. Fenton) wrote: And you should use either 6 or 8, not 7, which was a bugfest (8 is just the bug fix for 7).
Jet 4.0 SP8 also has the sandbox mode, etc, for better security which SP7 didn't.
SP7 was only out for what seemed to be three or four weeks before SP8 came out.
Dunno why they even bothered with SP7.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
"Tony Toews" Jet 4.0 SP8 also has the sandbox mode, etc, for better security which SP7
didn't.
What's sandbox mode?
Can you post a link to kb or MSDN for details?
Bye: Red tt****@telusplanet.net (Tony Toews) wrote in
<ie********************************@4ax.com>: dX********@bway.net.invalid (David W. Fenton) wrote:
And you should use either 6 or 8, not 7, which was a bugfest (8 is just the bug fix for 7).
Jet 4.0 SP8 also has the sandbox mode, etc, for better security which SP7 didn't. SP7 was only out for what seemed to be three or four weeks before SP8 came out. Dunno why they even bothered with SP7.
Actually, SP7 was out long before that, when the documentation web
page said it was applicable only to the beta of Access 2003.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc dX********@bway.net.invalid (David W. Fenton) wrote: Actually, SP7 was out long before that, when the documentation web page said it was applicable only to the beta of Access 2003.
Hmm, "I have no recollection". <smile>
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
HELP!
We have now made sure every user is running msjet40.dll service pack 8 as
well as ops locks registry setting added to the server. All users are
running windows 2000 with service pack 3 installed. After all this and we
are still experiencing corruption's. The corruption's usually start around
12:00 PM when database traffic gets heavier. As was stated before we never
experienced this problem before when we were running Win 2K service pack 3
on the Win NT server. Any more suggestions.
Regards,
Mark he******@yahoo.com
"Tony Toews" <tt****@telusplanet.net> wrote in message
news:j1********************************@4ax.com... "Mark" <he******@yahoo.com> wrote:
(Sorry for the delay. ISP not processing outbound messages for a few
days.)Thanks for your help but the changes you mentioned did not help.
The registry setting was added on the server side and all the client machines already have service pack 3. We had a total of 5 corruption's
todayin 2 different databases. Interesting. The OpLocks setting is definitely the first thing to check
with a new server.
We had a rep. from Microsoft on the phone today and he thinks that it is
notOps Locks that is the problem. He told us that the MSJET DLL that we are using is old but this is the same DLL we used in the Win NT server environment with no corruption's. We made the change this evening with
theDLL and just have to pray that it works. Microsoft told us to try this first and if it does not work to call them back. Do you think they know
whatthey are talking about? If anyone has any insight to this type of problem please by all means help us out. I guess if all else fails we can go back
tothe Win NT server were we had no corruption's but eventually we have to upgrade. What MSJet DLL and where does it reside? Presumably on all the client
systems. And not on the server. There is no need to install any Jet DLLs on the
server as Access running on the client workstations wouldn't use them.
Have you folks split the databases into a FE/BE with each user getting
their own copy of the FE?
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Mark,
Really dumb question - could you be running into issues caused by a
backup routine running on your server? We recently had a situation
somewhat similar to this that we traced to a backup that running while
users were still in the app. Yes, I know that shouldn't happen - but
when we changed the backup schedule, the problem went away. This was
a commercial app that we didn't have the source code for, but which is
Access-based. (In this case, we had users that are smart enough to
always log out!)
Also, have you checked that you don't have a flaky NIC card or bad
cabling? Access is quite sensitive to this. Given what you describe,
I don't think that is the case, but it might be worthwhile to
eliminate the possibility.
JCN
"Mark" <he******@yahoo.com> wrote in message news:<Nt********************@comcast.com>... HELP!
We have now made sure every user is running msjet40.dll service pack 8 as well as ops locks registry setting added to the server. All users are running windows 2000 with service pack 3 installed. After all this and we are still experiencing corruption's. The corruption's usually start around 12:00 PM when database traffic gets heavier. As was stated before we never experienced this problem before when we were running Win 2K service pack 3 on the Win NT server. Any more suggestions.
Regards, Mark he******@yahoo.com "Tony Toews" <tt****@telusplanet.net> wrote in message news:j1********************************@4ax.com... "Mark" <he******@yahoo.com> wrote:
(Sorry for the delay. ISP not processing outbound messages for a few days.)Thanks for your help but the changes you mentioned did not help.
The registry setting was added on the server side and all the client machines already have service pack 3. We had a total of 5 corruption's todayin 2 different databases.
Interesting. The OpLocks setting is definitely the first thing to check
with a new server.
We had a rep. from Microsoft on the phone today and he thinks that it is notOps Locks that is the problem. He told us that the MSJET DLL that we are using is old but this is the same DLL we used in the Win NT server environment with no corruption's. We made the change this evening with theDLL and just have to pray that it works. Microsoft told us to try this first and if it does not work to call them back. Do you think they know whatthey are talking about? If anyone has any insight to this type of problem please by all means help us out. I guess if all else fails we can go back tothe Win NT server were we had no corruption's but eventually we have to upgrade.
What MSJet DLL and where does it reside? Presumably on all the client systems. And not on the server. There is no need to install any Jet DLLs on the server as Access running on the client workstations wouldn't use them.
Have you folks split the databases into a FE/BE with each user getting their own copy of the FE?
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
JCN,
We have 2 back ups that run on around 6:00 AM and one around 6:00 PM both
are when there are no users in the database. I don't think flaky NIC cards
are the cause here due it being the same users pretty much everyday that use
the databases. I have another conference call scheduled for tomorrow with
our server staff and Microsoft ,wish me luck. I am running out of ideas.
Mark
"James Neumann" <bo*********@hotmail.com> wrote in message
news:77*************************@posting.google.co m... Mark,
Really dumb question - could you be running into issues caused by a backup routine running on your server? We recently had a situation somewhat similar to this that we traced to a backup that running while users were still in the app. Yes, I know that shouldn't happen - but when we changed the backup schedule, the problem went away. This was a commercial app that we didn't have the source code for, but which is Access-based. (In this case, we had users that are smart enough to always log out!)
Also, have you checked that you don't have a flaky NIC card or bad cabling? Access is quite sensitive to this. Given what you describe, I don't think that is the case, but it might be worthwhile to eliminate the possibility.
JCN
"Mark" <he******@yahoo.com> wrote in message
news:<Nt********************@comcast.com>... HELP!
We have now made sure every user is running msjet40.dll service pack 8
as well as ops locks registry setting added to the server. All users are running windows 2000 with service pack 3 installed. After all this and
we are still experiencing corruption's. The corruption's usually start
around 12:00 PM when database traffic gets heavier. As was stated before we
never experienced this problem before when we were running Win 2K service pack
3 on the Win NT server. Any more suggestions.
Regards, Mark he******@yahoo.com "Tony Toews" <tt****@telusplanet.net> wrote in message news:j1********************************@4ax.com... "Mark" <he******@yahoo.com> wrote:
(Sorry for the delay. ISP not processing outbound messages for a few days.) >Thanks for your help but the changes you mentioned did not help. > >The registry setting was added on the server side and all the client >machines already have service pack 3. We had a total of 5
corruption's today >in 2 different databases.
Interesting. The OpLocks setting is definitely the first thing to
check with a new server.
>We had a rep. from Microsoft on the phone today and he thinks that it
is not >Ops Locks that is the problem. He told us that the MSJET DLL that we
are >using is old but this is the same DLL we used in the Win NT server >environment with no corruption's. We made the change this evening
with the >DLL and just have to pray that it works. Microsoft told us to try
this >first and if it does not work to call them back. Do you think they
know what >they are talking about? If anyone has any insight to this type of
problem >please by all means help us out. I guess if all else fails we can go
back to >the Win NT server were we had no corruption's but eventually we have
to >upgrade.
What MSJet DLL and where does it reside? Presumably on all the client
systems. And not on the server. There is no need to install any Jet DLLs on the server as Access running on the client workstations wouldn't use them.
Have you folks split the databases into a FE/BE with each user getting their own copy of the FE?
Tony -- Tony Toews, Microsoft Access MVP Please respond only in the newsgroups so that others can read the entire thread of messages. Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Mark,
Would you mind posting back with the resolution? I'm very curious.
JCN
"Mark" <he******@yahoo.com> wrote in message news:<__********************@comcast.com>... JCN,
We have 2 back ups that run on around 6:00 AM and one around 6:00 PM both are when there are no users in the database. I don't think flaky NIC cards are the cause here due it being the same users pretty much everyday that use the databases. I have another conference call scheduled for tomorrow with our server staff and Microsoft ,wish me luck. I am running out of ideas.
Mark
"James Neumann" <bo*********@hotmail.com> wrote in message news:77*************************@posting.google.co m... Mark,
Really dumb question - could you be running into issues caused by a backup routine running on your server? We recently had a situation somewhat similar to this that we traced to a backup that running while users were still in the app. Yes, I know that shouldn't happen - but when we changed the backup schedule, the problem went away. This was a commercial app that we didn't have the source code for, but which is Access-based. (In this case, we had users that are smart enough to always log out!)
Also, have you checked that you don't have a flaky NIC card or bad cabling? Access is quite sensitive to this. Given what you describe, I don't think that is the case, but it might be worthwhile to eliminate the possibility.
JCN
"Mark" <he******@yahoo.com> wrote in message news:<Nt********************@comcast.com>... HELP!
We have now made sure every user is running msjet40.dll service pack 8 as well as ops locks registry setting added to the server. All users are running windows 2000 with service pack 3 installed. After all this and we are still experiencing corruption's. The corruption's usually start around 12:00 PM when database traffic gets heavier. As was stated before we never experienced this problem before when we were running Win 2K service pack 3 on the Win NT server. Any more suggestions.
Regards, Mark he******@yahoo.com "Tony Toews" <tt****@telusplanet.net> wrote in message news:j1********************************@4ax.com... > "Mark" <he******@yahoo.com> wrote: > > (Sorry for the delay. ISP not processing outbound messages for a few days.) > > >Thanks for your help but the changes you mentioned did not help. > > > >The registry setting was added on the server side and all the client > >machines already have service pack 3. We had a total of 5 corruption's today > >in 2 different databases. > > Interesting. The OpLocks setting is definitely the first thing to check with a new > server. > > >We had a rep. from Microsoft on the phone today and he thinks that it is not > >Ops Locks that is the problem. He told us that the MSJET DLL that we are > >using is old but this is the same DLL we used in the Win NT server > >environment with no corruption's. We made the change this evening with the > >DLL and just have to pray that it works. Microsoft told us to try this > >first and if it does not work to call them back. Do you think they know what > >they are talking about? If anyone has any insight to this type of problem > >please by all means help us out. I guess if all else fails we can go back to > >the Win NT server were we had no corruption's but eventually we have to > >upgrade. > > What MSJet DLL and where does it reside? Presumably on all the client systems. And > not on the server. There is no need to install any Jet DLLs on the server as > Access running on the client workstations wouldn't use them. > > Have you folks split the databases into a FE/BE with each user getting their own copy > of the FE? > > Tony > -- > Tony Toews, Microsoft Access MVP > Please respond only in the newsgroups so that others can > read the entire thread of messages. > Microsoft Access Links, Hints, Tips & Accounting Systems at > http://www.granite.ab.ca/accsmstr.htm
JCN,
Our conference call on Tuesday was with an Access developer for Microsoft.
He basically asked a bunch of questions about the databases that are getting
corrupted and told us that it sounds like they are soundly built. He
suggested the next step to be to loaded Service pack 4 for Win 2K on the
client and the server. It supposedly has more fixes for the Win 2K
redirector issues which he says are more of an issue with Access 2K then Ops
Locks. Unfortunately due to red tape at our company there is a chain of
command that we have to go through to get approval for Service Pack 4. We
may end up going back to the Win NT server in the meantime. The person from
Microsoft also made mention that if Service Pack 4 does not work we may have
to disable Ops Locks on all the client machines. THE SAGA CONTINUES......:(
Mark
"James Neumann" <bo*********@hotmail.com> wrote in message
news:77**************************@posting.google.c om... Mark,
Would you mind posting back with the resolution? I'm very curious.
JCN
"Mark" <he******@yahoo.com> wrote in message
news:<__********************@comcast.com>... JCN,
We have 2 back ups that run on around 6:00 AM and one around 6:00 PM
both are when there are no users in the database. I don't think flaky NIC
cards are the cause here due it being the same users pretty much everyday that
use the databases. I have another conference call scheduled for tomorrow
with our server staff and Microsoft ,wish me luck. I am running out of ideas.
Mark
"James Neumann" <bo*********@hotmail.com> wrote in message news:77*************************@posting.google.co m... Mark,
Really dumb question - could you be running into issues caused by a backup routine running on your server? We recently had a situation somewhat similar to this that we traced to a backup that running while users were still in the app. Yes, I know that shouldn't happen - but when we changed the backup schedule, the problem went away. This was a commercial app that we didn't have the source code for, but which is Access-based. (In this case, we had users that are smart enough to always log out!)
Also, have you checked that you don't have a flaky NIC card or bad cabling? Access is quite sensitive to this. Given what you describe, I don't think that is the case, but it might be worthwhile to eliminate the possibility.
JCN
"Mark" <he******@yahoo.com> wrote in message news:<Nt********************@comcast.com>... > HELP! > > We have now made sure every user is running msjet40.dll service pack
8 as > well as ops locks registry setting added to the server. All users
are > running windows 2000 with service pack 3 installed. After all this
and we > are still experiencing corruption's. The corruption's usually start around > 12:00 PM when database traffic gets heavier. As was stated before we never > experienced this problem before when we were running Win 2K service
pack 3 > on the Win NT server. Any more suggestions. > > > Regards, > Mark > he******@yahoo.com > > > > "Tony Toews" <tt****@telusplanet.net> wrote in message > news:j1********************************@4ax.com... > > "Mark" <he******@yahoo.com> wrote: > > > > (Sorry for the delay. ISP not processing outbound messages for a
few days.) > > > > >Thanks for your help but the changes you mentioned did not help. > > > > > >The registry setting was added on the server side and all the
client > > >machines already have service pack 3. We had a total of 5 corruption's today > > >in 2 different databases. > > > > Interesting. The OpLocks setting is definitely the first thing
to check with a new > > server. > > > > >We had a rep. from Microsoft on the phone today and he thinks
that it is not > > >Ops Locks that is the problem. He told us that the MSJET DLL that
we are > > >using is old but this is the same DLL we used in the Win NT
server > > >environment with no corruption's. We made the change this evening with the > > >DLL and just have to pray that it works. Microsoft told us to
try this > > >first and if it does not work to call them back. Do you think
they know what > > >they are talking about? If anyone has any insight to this type of problem > > >please by all means help us out. I guess if all else fails we can
go back to > > >the Win NT server were we had no corruption's but eventually we
have to > > >upgrade. > > > > What MSJet DLL and where does it reside? Presumably on all the
client systems. And > > not on the server. There is no need to install any Jet DLLs on
the server as > > Access running on the client workstations wouldn't use them. > > > > Have you folks split the databases into a FE/BE with each user
getting their own copy > > of the FE? > > > > Tony > > -- > > Tony Toews, Microsoft Access MVP > > Please respond only in the newsgroups so that others can > > read the entire thread of messages. > > Microsoft Access Links, Hints, Tips & Accounting Systems at > > http://www.granite.ab.ca/accsmstr.htm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: John Finch |
last post by:
We are running SQL 7 on a Windows NT Server. If you copy a 25Mb file
from this machine to a W2K server, the file copy takes over 5 minutes
on a 100Mpbs switched network.
Copying the same file to...
|
by: Mark |
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...
|
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.
...
|
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...
|
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...
| |
by: serge calderara |
last post by:
Dear all,
I clearly underdand the advantage of both type of authentification but is it
allowed or possible to set the Authentication mode to Windows and then handle
a login form for defined...
|
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...
|
by: DaBrain |
last post by:
I am no DBA, but this is my task.
I have an SQL Server 2000 Database that has an "SQL Account" that has
execute permission on all Stored procedures. it is what was used by
the company. This...
|
by: brian.j.parker |
last post by:
One of the developers where I work found that some of his code would
regularly cause index corruption in SQL Server 2000, post-sp4.
@@version is 8.00.2050 and I can repeat this, so I can't...
|
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...
|
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...
| |
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,...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 ...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |