Paula, Yes they are. Any other ideas of where I might look for this problem?
Thanks Joel ----- Original Message ----- From: "Paula Stuart" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Monday, May 23, 2005 11:57 AM Subject: [RBG7-L] - RE: Memory allocation > 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] >
