Missing data in MS Access db records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, this is from a previous thread which I had been receiving help on but
I have not replied to the last reply in that thread in awhile, so decided to
being anew. We have some PCs which are running MS Access 97 dbs that query
against an MS SQL database, that are missing a couple of records. These same
records appear on other PCs in the db. We have tried upgrading the ODBC
driver, the MS Jet driver, removing and recreating the ODBC DSN, with no
luck. Thank you to Duane who was helping us on this. Here is some updated
information.

The querys in Access:

SELECT dbo_DAILY_PROC_STATS.DPS_PID, dbo_DAILY_PROC_STATS.DPS_DAILY_START,
dbo_DAILY_PROC_STATS.DPS_DAILY_ELAPSED, ([DPS_DAILY_ELAPSED]/1000)/60 AS
daily_elapsed_min, dbo_DAILY_PROC_STATS.DPS_DAILY_START_DT,
dbo_DAILY_PROC_STATS.DPS_DAILY_NEXT_START_DT,
dbo_DAILY_PROC_STATS.DPS_TASKS_ELAPSED, ([DPS_TASKS_ELAPSED]/1000)/60 AS
tasks_elapsed_min, dbo_DAILY_PROC_STATS.DPS_REPORTS_ELAPSED,
([DPS_REPORTS_ELAPSED]/1000)/60 AS reports_elapsed_min,
dbo_DAILY_PROC_STATS.DPS_EXTRACTS_ELAPSED, ([DPS_EXTRACTS_ELAPSED]/1000)/60
AS extracts_elapsed_min, qryCycleFinished.cycle_finish_dt
FROM dbo_DAILY_PROC_STATS LEFT JOIN qryCycleFinished ON
dbo_DAILY_PROC_STATS.DPS_PID = qryCycleFinished.dps_pid
WHERE (((dbo_DAILY_PROC_STATS.DPS_DAILY_START)>=DateAdd("m",-1,Date())))
ORDER BY dbo_DAILY_PROC_STATS.DPS_DAILY_START DESC;

qryCycleFinished:

SELECT dbo_daily_proc_activity.dpa_id, dbo_daily_proc_activity.dps_pid,
dbo_daily_proc_activity.finish_dt AS cycle_finish_dt, ([elapsed_num]/1000)/60
AS cycle_elapsed_minutes
FROM dbo_daily_proc_activity
WHERE (((dbo_daily_proc_activity.activity_desc)="daily elapsed"));

Regards,

Randy
 
Back
Top