[Solved] Out of Memory Error

[TJM05]

Hello All,
My Main Customer table has become corrupted (I'm assuming) and the table will not open. When I attempt to open the table I get the following error:

THE DATA CONTENT COULD NOT BE LOADED. out of memory.

When I click the MORE button I receive the following information:


SQL Status: S1000
Error code: 72

out of memory

AND:

The SQL command leading to this error is:

SELECT * FROM "Orders"

("Orders" is the name of the table that will not open.)

I have tried SHUTDOWN COMPACT and get this message:

1: File input/output error: mydb.script.new in statement [SHUTDOWN COMPACT]

And then in my db folder I see I have a mydb.script AND a mydb.script.new file

I have recently moved to a multi-user set up so I'm wondering if there are duplicate records or some other conflict going on.

ANY help would be greatly appreciated. I am dead in the water until I can get this fixed. Even though I have been utilizing my db for quite sometime without major problems, I'm still rather new to the intricacies of db management.

Thank you!
TJM05

[Sliderule]

Since no one else has responded yet, I am sending you a PM ( Private Message ).

Sliderule

[TJM05]

OK, what happened is that the file had become so large that the data was inaccessible. I had not run a checkpoint defrag, which is the key to keeping the files manageable. I had a back up from last week that I was able to use before the problem began... and I immediately used ran the Checkpoint Defrag in the SQL command screen and the .data file shrunk extensively. Looks like I'm good to go.

Thank you so much to Sliderule for all your help!