ISAM Error

[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

 

[Douglas J. Steele]

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)

 

[DS]

Thanks Doug.
Seems to be working now.
DS