bigjoe

I tried to save a compact copy and the whole system froze. I left it overnight, and it was still frozen. I forgot to mention another oddity, if I try to go to record # 56, the system freezes. I tried to delete it and the system froze. Is it possible that one record is corrupt?

Is it normal for it to do it every time I open up the file? I know it isn't compressing because I removed all of the embedded files, and the size hasn't gone down.

I have a particular file very large in size 10gb. I was imbedding files into the database and recently changed it to have a short cut to the file. Two problems with the file, when I close the file it tries to compress it and isn't successful, it takes a long time, but there is no error. When I then reopen it says it is scanning for unused blocks. This takes about 20 minutes each time. Recently I opened up another file and it is doing the same thing, scanning for unused blocks. Any help is greatly appreciated. Thanks

We have thousands of scans that we have everything embeded into the database. Is there a quick way or method to switch to referencing. Rescanning the files isn't an option as there are thousands of scans.

So by reference the file will be stored in a folder system on the hard drive not within the db correct?

I'm very new to Filemaker, I have at my company several large datbases. Some of them have increased to 10gb in size as we are scanning a lot of information for past employee files. I have noticed that these files are getting corrupt often and I have to restore from backup. The problem being is that I don't know when they became corupt. I have tried to rebuild the db through filemaker which takes a long time and says that it is too corrupt to rebuild. Should I not be using FM with such large files. I'm trying to convnince my employer that we should just use folders withing Windows instead. Any help or information regarding file limitations is greatly appreciated.