Search results for query: *

Thank you so much. I copied and pasted that into my project and it worked GREAT!!!! I don't know how I could ever repay you but you were awesome! [2thumbsup]

I copied and pasted that sql statement into my project. I produced the cumulative results instead of the individual errors for the day.

Just as a test, I created a table with the entries from just one of the routers. When I ran this query: SELECT R.DDateTime, (R.CRC-Nz(T.CRC,0)) As CRCerrors,R.CRC,T.CRC,T.DDateTime FROM RouterTable AS R LEFT JOIN RouterTable AS T ON R.DDateTime = T.DDateTime+1; Against that test table it...

That string displays the data just as if I did a select of the two fields in that table. I've tried tweaking it a bit to no avail.

Here's a copy of my sql statement: SELECT R.DDateTime, IIf(DMin("[DDateTime]","RouterTable")=r.DDateTime,R.crc,(R.crc-S.crc)) AS Expr1 FROM RouterTable AS R, RouterTable AS S WHERE ((([R].[DDateTime])=IIf(DMin("[DDateTime]","RouterTable")=[r].[DDateTime],[s].[DDateTime],[s].[DDateTime]+1)));

I've tried to incorporate this into my db but ran into some issues. All the data is stored in a table called RouterTable with the two fields DDateTime and CRC. When I replaced "test" with "RouterTable" and [date] with [DDateTime] and ran the query, it returned 361 repetitive records when it...

I have a table that reports errors on a router as of a particular time. This reports once a day just before midnight. The problem is, the router reports the cumulative errors since the last time it was rebooted (which clears the errors and starts the error counter at zero). Here is a sample of...

:) That's actually the way I have been doing it up until now. I deleted those entries, purged the database and compacted and repaired the database at around 7AM each morning to keep it reasonable. Thanks for your help Tom!

I was afraid that it wouldn't be possible to automatically do this on the Access side. Unfortunately there is not way to restrict that on the Cisco side. I guess the timer is kind of a last resort option. I just don't want to tie up that box.

I'm unclear of the question but we've configure Cisco Secure to log directly to the Access database. We're not using any CSV (Comma Separated Value) files.

You'll have to forgive me because I'm very new! I have an Access database that receives logs of information from Cisco Secure ACS. This gives me information about users and devices (routers) that authenticate against Cisco Secure. I am then taking this data and running various reports. There...