Everyone please note that Aaron  Kem.pf is attempting to impersonate one of
our regular posters again.  Tom would never post such a message.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

Thank you for your pithy reply.  I am using Access in this instance as a
front end to a postgreSQL database on a unix server.  Perhaps a genius like
you could explain how to set up SQL Agent in this environment?

Thank you, knowing it can happen is good enough for now, I was afraid I was
loosing my mind (still a possibility) or the janitor was maliciously messing
with my computer at night.

I am using Access in something of a non-standard environment: as a front end
to a postgreSQL database running on a unix server.  At night I process
records from an online training system to determine which students, if any,
have become eligible for completion certificates, which have accounts about
to expire without completion, etc. etc. I have created an object (class
instantiated as an object to be more accurate) which does the processing.  I
have a form designated as the startup form, and in the form_open event I
instantiate the class and tell it to do it's job, then quit when the object
completes it's task.  Windows task scheduler starts the access application.  
I log every record before I process it, so I can tell where the job croaked,
but in the 3 years this has been working I have never encountered an instance
where access just 'went away', either I have trapped a given error in an
error log, or an error is on the screen when I come in in the morning.  Now
that I know that access can close without leaving a message I will tease out
the problem, though I think I will start with compact/repair and recompile,
as I write this I realize this hasn't been done in a while.  Perhaps related
to this, a couple of days ago I got a screen error telling me that,
basically, access had lost reference to an object while it was being used.  
This now leads me to think that corruption may have crept into the access
file.  Thank you for your reply.