"out of memory or system resources, close some windows and try again"??

[Ron2006]

I have two major applications running on a network with 10-15 users
each. Both applications use Office Automation to first send certain
emails and then to search the sent folder to capture the email and
save it to specific folders on the network. The applications have been
running fine for more than 18 months.
However, last week three of the computers running the application have
begun getting the out of virtual memory and/or system resources
message at the point of doing the search of the sent folder.
Does anyone have any ideas/suggestions as to the cause. I repeat not
all machines but only 3 certain machines. We set one of them to use 2G
for virtual memory and they still got the message.
We are running Access 2003, Windows XP w SP2, 512 ram and 10-20 Gig
hard drives with 50 to 90% free space on the harddrives.

Ron

 

[a a r o n . k e m p f]

sounds to me like you're relying on a crap database
sounds like a classic case of corruption-- when 'it works great until'
that means that you got bit by 'choosing an obsolete database'

File, New, Project (existing data) in Access 2003

 

[Ron2006]

Arron, I am afraid that your comments make no sense, since it is a
problem with searching outlook's sent folder that is encountering the
problem, not searching either the SQL tables or MDB tables.

Try a different approach, Arron.

Ron

 

[BruceM]

Aaron has only one approach. Nothing will be lost by ignoring him.

 

[Ron2006]

No argument from me, Bruce. I have seen Aaron's "replies ????" many
times.

I was trying to reply politely to his non-sequitor response. Probably
a wasted effort.

Ron

 

[a a r o n . k e m p f]

XP_SENDMAIL is perfectly reliable

and you only have to manage it in ONE PLACE instead of troubleshooting
Outlook probelms on 20 different desktops

I just believe that, by definition- it's easier using SQL Server

 

[a a r o n . k e m p f]

I personally import from outlook using an Access Database-- Outlook
and SharePoint are one place I use Jet-- but it's only so that I can
create a 'linked server'.. because it's DOG SLOW in Access... I just
DTS it into SQL Server so that I can search through it