I have resolved this problem. Incase anyone is interested, I wasn't
clearing my memory after a certain time period - dissabling Access from
running any kind of operation. So I closed the recordset and connection,
then set both to nothing.
Is there a way to limit the number of rows returned from a select
Please respond to my email address as well, I don't always have access
the news group.