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

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 14:37:52 -0500

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.

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: Linking Forms
    ... The second page code this must be an asp page ... This collects the information from the first form and stores it ... variables lines and then the fields of the sql insert to match your database ... To create the access database I often let frontpage do this for me by ...
    (microsoft.public.frontpage.client)
  • 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: 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)