Joel,
I've got similar selections running in forms against a database
of 300,000 records using XP Pro with 512 MB memory with no problems.
Are the lookup columns indexed?
Paula
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Joel
Solomon
Sent: Monday, May 23, 2005 11:46 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Memory allocation
Good Morning,
I would like to know if anyone has run into this problem. I get an
error in my form lookup that states that I do not have enough memory to
allocate to the lookup function. I have only 1,200 records and I am
using a multi-column lookup using 3 text columns. My computer has 512
MB of memory and I am running Windows XP. When I change the
mulit-column lookup to 2 text columns, the error goes away.
Short of increasing my memory, what else can I do? I find it quite
strange that 1,200 records would cause this kind of problem.
Thanks
Joel Solomon
V.P. Finance
Barbizon International
[EMAIL PROTECTED]
