Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820

    Question Unanswered: Very Odd Happerenings between MsQuery and access

    i'm a placement student at a UK manufacturing firm, under orders from my boss i've created a Excel speadsheet to format Access data but was informed by my boss that he was missing over half the required data now on my Win2K machine MSQuery was returning the following MachineID's: A02, A03, A04, A05, A06, A07, A08, A09, A10, B02, B03, B04, B05, B06, B07, B08, B09, B10, C01, C02, C03, C04, C05, D01, D02, D03, D04, D05 & E03 which is correct

    but on the bosses win98 machine msquery would only recognise C01, C02, C03, C04, C05, D01, D02, D03, D04, D05 & E03

    so somehow of it's own volision MSQuery on a Win98 machine removes all machines with a A## or B## designation,

    other data
    both computers are running Office 2000
    both computers are using the same networked database as a source
    the same problem occurs on other win98 machines i've tried.

    can anyone tell me :
    A. what the problem is
    B. any method short of completly upgrading the firm to win2k to fix the problem

  2. #2
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    this is the sql i'm using

    SELECT XLStoptime.MachineID, XLStoptime.StopDescription, XLStoptime.DateMonthYear
    FROM `J:\Measures\Machines\barco`.XLStoptime XLStoptime

    as yo ucan see extremly basic

  3. #3
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    i don't know if this has anything to do with it but the DB it's self is just being used to correleate the data from a odbc batabase called barco that links in to access through MS ODBC Drivers

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •