ldb File and Sharing Violations (server Speed Issue?)

We are migrating some asp based apps that use MS Access for the back end and
we are getting lots of intermittent errors whenever quesries are made and
whenever data is added or changed. the app is now on a server that is much
much faster than before. Filemon is showing SHARING VIOLATION errors for .ldb
files, but in many cases, despite the asp errors, the data is written to the
database and the error messages are wrong. Could this be a case where the CPU
speed on the server is too fast and is not allowing the database actvity to
cease before continuing with the asp page? If so, is there any way of slowing
the CPU down by way of asp code or should it be done from within IIS? Yuo can
gfo into the application pool properties and limit the amount of CPU or we
can go in and put in some sort of sleep command after every SQL statement is
executed.

Has anyone ever come across this and if so, what was done to resolve it?

Thanks, Rob Edmiston
Detroit, Meatchicken

Re: ldb File and Sharing Violations (server Speed Issue?)

What errors are you getting?

Might consider MSDE or SQLServer.

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"Jayhawktuba" wrote in message
news:C2F3D6AD-9B27-4442-97DB-A64644386FA8@microsoft.com...
> We are migrating some asp based apps that use MS Access for the back end
and
> we are getting lots of intermittent errors whenever quesries are made and
> whenever data is added or changed. the app is now on a server that is much
> much faster than before. Filemon is showing SHARING VIOLATION errors for
..ldb
> files, but in many cases, despite the asp errors, the data is written to
the
> database and the error messages are wrong. Could this be a case where the
CPU
> speed on the server is too fast and is not allowing the database actvity
to
> cease before continuing with the asp page? If so, is there any way of
slowing
> the CPU down by way of asp code or should it be done from within IIS? Yuo
can
> gfo into the application pool properties and limit the amount of CPU or we
> can go in and put in some sort of sleep command after every SQL statement
is
> executed.
>
> Has anyone ever come across this and if so, what was done to resolve it?
>
> Thanks, Rob Edmiston
> Detroit, Meatchicken

Re: ldb File and Sharing Violations (server Speed Issue?)

Thanks much for the very prompt reply...

We are intermittently receiving either of the following two messages:

1)
|80004005|The_changes_you_requested_to_the_table_were_not_su ccessful_because_they_would_create_duplicate_values_in_the_i ndex__primary_key__or_relationship.__Change_the_data_in_the_ field_or_fields_that_contain_duplicate_data__remove_the_inde x__or_redefine_the_index_to_permit_duplicate_entries_and_try _again.

2)
|800a0bcd|Either_BOF_or_EOF_is_True__or_the_current_record_h as_been_deleted._Requested_operation_requires_a_current_reco rd.

Despite the errors, the database actually DOES reflect the proper data when
you go into verify that the data exists properly. I concur on your MS SQL
suggestion. I wish that I could aboloish the use of MS Access in a corporate
environment, but unfortunately, that is not an option at this point.

"Mark Schupp" wrote:

> What errors are you getting?
>
> Might consider MSDE or SQLServer.
>
> --
> Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
>
> "Jayhawktuba" wrote in message
> news:C2F3D6AD-9B27-4442-97DB-A64644386FA8@microsoft.com...
> > We are migrating some asp based apps that use MS Access for the back end
> and
> > we are getting lots of intermittent errors whenever quesries are made and
> > whenever data is added or changed. the app is now on a server that is much
> > much faster than before. Filemon is showing SHARING VIOLATION errors for
> ..ldb
> > files, but in many cases, despite the asp errors, the data is written to
> the
> > database and the error messages are wrong. Could this be a case where the
> CPU
> > speed on the server is too fast and is not allowing the database actvity
> to
> > cease before continuing with the asp page? If so, is there any way of
> slowing
> > the CPU down by way of asp code or should it be done from within IIS? Yuo
> can
> > gfo into the application pool properties and limit the amount of CPU or we
> > can go in and put in some sort of sleep command after every SQL statement
> is
> > executed.
> >
> > Has anyone ever come across this and if so, what was done to resolve it?
> >
> > Thanks, Rob Edmiston
> > Detroit, Meatchicken
>
>
>

Re: ldb File and Sharing Violations (server Speed Issue?)

Jayhawktuba wrote:
> We are migrating some asp based apps that use MS Access for the back
> end and we are getting lots of intermittent errors whenever quesries
> are made and whenever data is added or changed. the app is now on a
> server that is much much faster than before. Filemon is showing
> SHARING VIOLATION errors for .ldb files, but in many cases, despite
> the asp errors, the data is written to the database and the error
> messages are wrong. Could this be a case where the CPU speed on the
> server is too fast and is not allowing the database actvity to cease
> before continuing with the asp page?

No. This is usually a file perimissions problem. All users of the database
require Change/Modify authority for the folder containing the database.

> If so, is there any way of
> slowing the CPU down by way of asp code or should it be done from
> within IIS?

No.

> Yuo can gfo into the application pool properties and
> limit the amount of CPU or we can go in and put in some sort of sleep
> command after every SQL statement is executed.
>

Don't do that.

> Has anyone ever come across this
> it?

No

> and if so, what was done to resolve

Sharing issues are usually resolved by fixing permissions
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: ldb File and Sharing Violations (server Speed Issue?)

This is an anoymous access IIs website. The access database is in a folder
called "database" and the IUSR_ account has CHANGE access to the folder and
in IIS permissions WRITE access is enabled.. This is a secured access db. The
database is named xxxx.mdb and the workgroup system file is named
"system.mdw" That is also in the /database folder. The database is connected
to via a DSN that is referenced in a connection string.

"Bob Barrows [MVP]" wrote:

> Jayhawktuba wrote:
> > We are migrating some asp based apps that use MS Access for the back
> > end and we are getting lots of intermittent errors whenever quesries
> > are made and whenever data is added or changed. the app is now on a
> > server that is much much faster than before. Filemon is showing
> > SHARING VIOLATION errors for .ldb files, but in many cases, despite
> > the asp errors, the data is written to the database and the error
> > messages are wrong. Could this be a case where the CPU speed on the
> > server is too fast and is not allowing the database actvity to cease
> > before continuing with the asp page?
>
> No. This is usually a file perimissions problem. All users of the database
> require Change/Modify authority for the folder containing the database.
>
> > If so, is there any way of
> > slowing the CPU down by way of asp code or should it be done from
> > within IIS?
>
> No.
>
> > Yuo can gfo into the application pool properties and
> > limit the amount of CPU or we can go in and put in some sort of sleep
> > command after every SQL statement is executed.
> >
>
> Don't do that.
>
> > Has anyone ever come across this
> > it?
>
> No
>
> > and if so, what was done to resolve
>
> Sharing issues are usually resolved by fixing permissions
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>
>

Re: ldb File and Sharing Violations (server Speed Issue?)

Jayhawktuba wrote:
> We are migrating some asp based apps that use MS Access for the back
> end and we are getting lots of intermittent errors whenever quesries
> are made and whenever data is added or changed. the app is now on a
> server that is much much faster than before. Filemon is showing
> SHARING VIOLATION errors for .ldb files, but in many cases, despite
> the asp errors, the data is written to the database and the error
> messages are wrong. Could this be a case where the CPU speed on the
> server is too fast and is not allowing the database actvity to cease
> before continuing with the asp page? If so, is there any way of
> slowing the CPU down by way of asp code or should it be done from
> within IIS? Yuo can gfo into the application pool properties and
> limit the amount of CPU or we can go in and put in some sort of sleep
> command after every SQL statement is executed.
>
You could be running into a Jet cache issue. See here:

http://msdn.microsoft.com/library/en-us/oledb/htm/oledbprovj et_file_caching_and_data_consistency.asp


http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefjetp rovspec.asp

http://msdn.microsoft.com/library/en-us/bapp2000/html/acbach ap07.asp

http://msdn.microsoft.com/archive/en-us/dnaraccessdev/html/O DC_MicrosoftJetlockingtechniques.asp

Make sure you are minimizing your connection time. Don't use slow recordsets
for data maintenance. Use saved queries as much as possible.Close
connections as soon as possible.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: ldb File and Sharing Violations (server Speed Issue?)

Is there a possibility that the requests are being submitted more than one
time?

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"Jayhawktuba" wrote in message
news:09045E15-0AD5-48B8-A571-3A44487907DE@microsoft.com...
> Thanks much for the very prompt reply...
>
> We are intermittently receiving either of the following two messages:
>
> 1)
>
|80004005|The_changes_you_requested_to_the_table_were_not_su ccessful_because
_they_would_create_duplicate_values_in_the_index__primary_ke y__or_relationsh
ip.__Change_the_data_in_the_field_or_fields_that_contain_dup licate_data__rem
ove_the_index__or_redefine_the_index_to_permit_duplicate_ent ries_and_try_aga
in.
>
> 2)
>
|800a0bcd|Either_BOF_or_EOF_is_True__or_the_current_record_h as_been_deleted.
_Requested_operation_requires_a_current_record.
>
> Despite the errors, the database actually DOES reflect the proper data
when
> you go into verify that the data exists properly. I concur on your MS SQL
> suggestion. I wish that I could aboloish the use of MS Access in a
corporate
> environment, but unfortunately, that is not an option at this point.
>
> "Mark Schupp" wrote:
>
> > What errors are you getting?
> >
> > Might consider MSDE or SQLServer.
> >
> > --
> > Mark Schupp
> > Head of Development
> > Integrity eLearning
> > www.ielearning.com
> >
> >
> > "Jayhawktuba" wrote in message
> > news:C2F3D6AD-9B27-4442-97DB-A64644386FA8@microsoft.com...
> > > We are migrating some asp based apps that use MS Access for the back
end
> > and
> > > we are getting lots of intermittent errors whenever quesries are made
and
> > > whenever data is added or changed. the app is now on a server that is
much
> > > much faster than before. Filemon is showing SHARING VIOLATION errors
for
> > ..ldb
> > > files, but in many cases, despite the asp errors, the data is written
to
> > the
> > > database and the error messages are wrong. Could this be a case where
the
> > CPU
> > > speed on the server is too fast and is not allowing the database
actvity
> > to
> > > cease before continuing with the asp page? If so, is there any way of
> > slowing
> > > the CPU down by way of asp code or should it be done from within IIS?
Yuo
> > can
> > > gfo into the application pool properties and limit the amount of CPU
or we
> > > can go in and put in some sort of sleep command after every SQL
statement
> > is
> > > executed.
> > >
> > > Has anyone ever come across this and if so, what was done to resolve
it?
> > >
> > > Thanks, Rob Edmiston
> > > Detroit, Meatchicken
> >
> >
> >

Re: ldb File and Sharing Violations (server Speed Issue?)

Here's another, from aspfaq:
http://support.microsoft.com/default.aspx/kb/200300
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"