Checking Daily Record Count in Access Table 1

[RDMRDM]

We have a table that gets created each evening. We would like to create something that would run each morning that would check the record count and notify us if we appear to be missing records. For example, this table usually has around 21000 records. This morning, it only had 1497 records because a nightly process was delayed. Does anyone have any suggestions or a process/database to share that would help us in identifying a potential issue like this? Thanks in Advance.

 

[PaulBricker]

You could use MS Scheduler to open Access each morning and then have a function inside Access that runs and checks the size of the recordset. If the size is not within the limits set in the Function (or even if it is), you could email someone automatically with the recordset size.
Post back if that's the type of thing you are looking for.

Paul

 

[RDMRDM]

Yeah, thats what I am looking for. Where can find MS Scheduler at? I don't seem to have it on my system anywhere. Should it be there? Or do I need to download? Thanks for the help.

 

[PaulBricker]

If you are running XP, scheduler is in the Control Panel. If by some off chance you are running Win 98 (don't laugh)it's an icon in the lower right hand box of the Start Bar. For everything else, I would assume it might be in Control Panel.


Paul

 

[PaulBricker]

P.S.
In XP, it's called - "Scheduled Tasks"


Paul

 

[RDMRDM]

Found it. Thanks again for all your help.