Re: Slow Access

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

From: Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP] (sbradcpa_at_pacbell.net)
Date: 05/08/04 

Date: Sat, 08 May 2004 00:01:05 -0700

Whenever working with databases.....

1. Disable digital signing
http://www.smallbizserver.net/DesktopDefault.aspx?tabid=98

2. Disable oplocking
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q296264

3. Disable autodisconnect
http://support.microsoft.com/default.aspx?scid=kb;EN-US;138365

Are you sure the files properly migrated?

Chris wrote:
> We have recently migrated our files from a Netware 3.x
> server to a SBS2003. We have also upgraded all users
> from Office 2000 Pro and Win 2k Pro to XP Pro and Office
> 2003 Pro. A MS Access database we regulary use is now
> slower than ever, it wasn't slow before. The database is
> in Access 2000 format. We also get some erros, see
> below. All the workstaions are Dell P4-2.8 w/512mb RAM.
> The server is a Dual P600 w/1gb of RAM and only one NIC.
>
> Errors:
> Your DB 2002 database or project contains missing or
> broken reference to the file 'MSOWCF.DLL' version 1.0.
>
> Your DB 2002 database or project contains missing or
> broken reference to the file '1.'
>
> Your DB 2002 database or project contains missing or
> broken reference to the file 'NAVSTATS.DLL' version 1.0.
>
> Your DB 2002 database or project contains missing or
> broken reference to the file 'WPWIZDLL.DLL' version 1.0.
>
> I know you can uncheck the missing files but are they
> required? I also suspect it is an old database possibly
> migrated from Access 97.
>
> Please help 

-- 
http://www.sbslinks.com/really.htm

Relevant Pages

  • Re: eseutil /p will nicht brauche dringend Hilfe!!!
    ... provides information about recovering the database if error -1216 occurs. ... the re-integration of the missing files with the data set. ... you can use an option in Eseutil to override ... the error and proceed with soft recovery despite missing or mismatched ...
    (microsoft.public.de.german.exchange2000.general)
  • RE: Events to "Trap" Incomplete Record Creation?
    ... validation checks and issue a message if anything is missing. ... Joe CluelessUser is adding a new record to a database through a form. ... because of the missing required data. ...
    (microsoft.public.access.formscoding)
  • Re: Convert a2000 back to a97
    ... Your computer is missing some of the DLL's or TLB's that come with Access ... The proper way to fix the References is to open the application in Access ... has the database connection hard-coded to use data access methods specific ... Those simple loads and conversions you mentioned -- could ...
    (microsoft.public.access.conversion)
  • Re: Merge in Word
    ... Peter - that was the problem! ... (here's was missing at certain numbered entries - mine is variable). ... characters" - that sort of thing. ... This has happened when the database is a simple address database in table ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merge in Word
    ... (here's was missing at certain numbered entries - mine is variable). ... "Peter Jamieson" wrote: ... characters" - that sort of thing. ... work when I didn't use Excel for the database. ...
    (microsoft.public.word.mailmerge.fields)