Re: Access 97 placing info in wrong field when record is edited or upd

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 09:25:39 +0800

It is crucial to get a single, registered copy of the latest DLL on each
machine. My copy is 3.51.3328.0, so it looks like you have a couple of
machines that have this installed. If all machines claim to be SR-2, you
could perhaps replace the old one with the 3.51.3328.0 DLL, and register it
the new one with regsvr32.

The other crucial file is DAO350.DLL (not dap...), and you will find it
somewhere on the drive, probably under \Program Files. Make sure there's
only one copy, and consistent versions. DAO stands for "Data Access
Objects", and Access won't work without it. 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"doglover" <doglover@discussions.microsoft.com> wrote in message 
news:C0D1CC9B-8BF4-45FA-89C7-83E82396008F@microsoft.com...
> 2/24/05.  Thank you for your help.  I found some interesting results. 
> None
> of the workstations contained the dap350.dll, nor did the server.  All
> machines (including the server) contained msjet35.dll but with different
> versions.  Server(using windows 2000) has two file versions: 3.51.2026
> (C:WINNT/System32)installed 8/25/98 and 3.51.2723.0
> (D:/Office97/OS/System)installed 1/21/05.  Workstation Kathy (using 
> windows
> 98)has three file versions: 3.51.2723.0 (C:/Windows/System)installed 
> 4/23/99,
> version 3.51.0623.4 (C:Old_data/GlobalStart/Top500)installed 7/21/97,
> version: 3.51.2026.0(C:Old_data/WINDOWS/SYSTEM)installed 3/11/99. 
> Workstation
> Gwen Version 3.51.3328.0 (C:/WINDOWS/SYSTEM installed 9/28/99.  My home
> computer has both files.  dap350.dll version 3.51.1608.0 and msjet35.dll
> version 3.51.3328.0.  Since the dap350.dll file is missing from all
> workstations could this be part of the problem?  Is the 3.51.1608.0 the 
> most
> recent? Guess this file needs to be installed?   Appears we have major
> confusion with the msjet35.dll files on the workstations and server. What 
> is
> the most recent version?  Sounds like the wrong files should be removed.
> Thanks for your help.  Can't wait to resolve this problem, will be
> interesting!
>
> "doglover" wrote:
>
>> The table (called workorder table) that this form (workorder) originates 
>> from
>> has over 6500 records.  When I edit or update the workorder form one of 
>> the
>> fields on the form actually places information in another field called
>> wrkky_inv (this field is related to another table called invoice table 
>> and is
>> a result of an invoice being created and is the primary key for the 
>> invoice
>> table).  The edited information is placed in the correct field correctly. 
>> The
>> problem is that when editing information (usually a field called work
>> completed qty) the form also places information into the wrkky_inv field
>> (uses the same number as the wrkid field which is the primary key for the
>> workorder table). To simpilify:  The form incorrectly places information 
>> in
>> the wrkky_inv field by copying the wrkid field information.   I should 
>> note
>> this does not happend on my computer at home (which is a copy of the data
>> table and program table).  This only occurs when information is recorded 
>> at
>> work where the data table is saved on our server. The program table is 
>> stored
>> on each workstation/computer and linked to the data db.  My computer at 
>> home
>> has one file with the program db and data db together.   Any suggestions. 
>> I
>> have made sure that the Office 97 updates are current (sr2).  Thank you.

Relevant Pages

  • Re: Clustering
    ... You mentioned WS's above and I assume that means WorkStations. ... Every fifth machine is a boot server. ... Each boot server serves four other machines. ... files were stored on the disk server. ...
    (comp.os.vms)
  • Re: Q329873, problems with DCs machine account, need help!
    ... Your best path is to disjoin and then rejoin the workstations to the domain. ... The NETDOM command would do most of the same functions and you may as well ... > couple Mac OSX 10.3 machines to participate in AD. ... > server, so that's obviously not good enough. ...
    (microsoft.public.win2000.active_directory)
  • RE: Windows Universal Storage Server 2003 quits working
    ... day) stops communicating with the domain controllers. ... but no other machines are affected (either servers or ... Local workstations can access files, ... The Server is a Dell NX1950 with a MD3000 Raid Enclosure. ...
    (microsoft.public.windows.server.general)
  • SMS Advanced Clients
    ... 2nd server has SQL, SMS and is the sole MP. ... I am able to locate my network machines that I wish to make clients and even ... Viewing the workstations ... they appear to have installed the client software. ...
    (microsoft.public.sms.setup)
  • Performance optimization vs satisficing (was Language Oriented Programming)
    ... >machines that were too small. ... Microsoft has been a leading offender here. ... >arcane issue for server engines. ... magnitude slower, yes, I recall working on a 200mb database, trying to ...
    (comp.object)
Loading