I think I have figured it out. I deleted the rbase.cfg file and it doesn't give the error anymore.
Dan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Petersen Sent: Tuesday, November 20, 2001 3:21 AM To: [EMAIL PROTECTED] Subject: Re: Problem creating and dropping tables Dan, Do you have a cursor declared against the table? Ben Petersen On 20 Nov 2001, at 10:57, Dan Goldberg wrote: > I have a command that creates a temporary table. > > drop table costtemp nocheck > create temporary table costtemp (serial int) > > First it drops the table in case something happened. > > It works sometimes and doesn't other times. It gives me the multi-user error > message > > "Resources required by command are not available" with the "retry" and > "cancel" buttons. > > Then gives me the error > > "Unavailable resource encountered during DROP command(2440)." > > What is unusual is if I turn off the "error messages" setting it will most > of the time work. But if I turn on the "error messages" it will never work. > > Since it is a temporary table it shouldn't be concerned with multi-user > issues. > > Anybody have ideas?? > > I am using window version 6.5+ 1839XRT03 > > > Dan Goldberg > >
