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

From: Jayhawktuba (Jayhawktuba_at_discussions.microsoft.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 11:31:03 -0800

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_successful_because_they_would_create_duplicate_values_in_the_index__primary_key__or_relationship.__Change_the_data_in_the_field_or_fields_that_contain_duplicate_data__remove_the_index__or_redefine_the_index_to_permit_duplicate_entries_and_try_again.

2)
|800a0bcd|Either_BOF_or_EOF_is_True__or_the_current_record_has_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" <Jayhawktuba@discussions.microsoft.com> 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
>
>
>

Relevant Pages

  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Validate logins with ASP, MS Access and Cookies error
    ... If you plan to do much more ASP, I would advise looking for tutorials ... return another column from the database that stores the users 1st name ... 'create connection and recordset objects ... Set cnStr = Server.CreateObject ...
    (microsoft.public.inetserver.asp.db)
  • Re: Datasets - Best approach to use?
    ... William (Bill) Vaughn ... then you got the wrong books. ... Using ASP (or ... It accesses data in an SQL Server database. ...
    (microsoft.public.vb.database)
  • Re: Database and asp question
    ... You and others can have access to a database hosted on the Web from any ... Then "dynamic" Web pages (actually ASP pages which include VBScript, ... Dynamic Web pages are similar in many ways to regular HTML pages. ... there is an autonumber field in each table (and you'll probably also ...
    (microsoft.public.inetserver.asp.db)
  • Re: newbie question on asp
    ... I am new to asp, and want to put a simple database on the web so the ... You and others can have access to a database hosted on the Web from any ... Dynamic Web pages are similar in many ways to regular HTML pages. ... Here are a few good ASP sites: ...
    (microsoft.public.inetserver.asp.db)