All,



I have a database that is about 220MB, when I try to compact and repair 

the datbase I get the error message "Can not find field 'Description'" 

There is no field in any of the tables called Description. In the 

directory where the database is stored a copy of the db is made (ALL 

220MB) and I have to manually delete it.



I have tried creating a new db and copying all the objects in, but I still 

get the same problem when I try to compact the database.



Any help would be greatly appreciated.

Paul 

This reminds me of something I came across years ago ... I believe it had 

to do with trying to compact a database on a network drive -- I got all 

sorts of messages that turned out to be red herrings; sometimes it just 

hung. The solution (read: workaround) was to copy the database to a local 

drive, compact it, then put it back on the network.  Another problem I'd 

run across with weird messages was lack of memory.

Hope this helps,

... AL





> All,

> 

> I have a database that is about 220MB, when I try to compact and repair 

> the datbase I get the error message "Can not find field 'Description'" 

> There is no field in any of the tables called Description. In the 

> directory where the database is stored a copy of the db is made (ALL 

> 220MB) and I have to manually delete it.

> 

> I have tried creating a new db and copying all the objects in, but I 

still 

> get the same problem when I try to compact the database.

> 

> Any help would be greatly appreciated.

> Paul 

Paul, I think this happened to me once because I was referring to a field 

in my code/sql that referred to a field that I renamed. Maybe try 

searching your code modules for "Description" and see what you find. Also 

look at your queries.

Carol :-)



>All, I have a database that is about 220MB, when I try to compact and 

repair the datbase I get the error message "Cannot find 

field 'Description'". There is no field in any of the tables called 

Description. In the directory where the database is stored a copy of the 

db is made (ALL 220MB) and I have to manually delete it. I have tried 

creating a new db and copying all the objects in, but I still get the same 

problem when I try to compact the database. Any help would be greatly 

appreciated. > Paul