ISAM Error

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

I'm running this code and I'm getting an ISAM error. 3170

Set RS = CurrentDb.OpenRecordset("SELECT Count(*) FROM " & _
"[MSAccess;Database=\\Backoffice\C$\Warehouse\History.mdb].tblDiscountDetails
" & _
"WHERE (CDBizDay BETWEEN " & Format(Forms!frmReportDates!TxtStart,
"\#yyyy\-mm\-dd\#") & " AND " & Format(Forms!frmReportDates!TxtEnd,
"\#yyyy\-mm\-dd\#") & ") AND CDDiscountManID = " & Me.EmployeeID,
dbOpenSnapshot)

Me.TxtDiscounts = Nz(RS(0), 0)
RS.Close

I'm using XP Pro 2002 Service Pack 2
And Access 2002 Service Pack 3

Thanks
DS
 
Try removing the MSAccess, and just using

Set RS = CurrentDb.OpenRecordset("SELECT Count(*) FROM " & _
"[;Database=\\Backoffice\C$\Warehouse\History.mdb].tblDiscountDetails
" & _
"WHERE (CDBizDay BETWEEN " & Format(Forms!frmReportDates!TxtStart,
"\#yyyy\-mm\-dd\#") & " AND " & Format(Forms!frmReportDates!TxtEnd,
"\#yyyy\-mm\-dd\#") & ") AND CDDiscountManID = " & Me.EmployeeID,
dbOpenSnapshot)
 
Back
Top