First allow me to thank everyone, this has been more helpful then you will ever know.

After getting it to send the email, of course this was not enough for managment,...

Yes, about 200. 3/4 of them are dates that we must have, for example drivers license expiration, last physical, last drug screen, last positive drug screen, accident #1,2,3,4, it goes...

I assume by that response I am trying something that can't be done.

However, I changed the string to below:

Dim connStr

  connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("\aspdb\db1.mdb")

 I also I change the...