I am using FMP 7 on a Windows XP Pro box.

I have a database of about 125 records, one table, and about 300 fields in that table. One of the fields is a container field into which I have been dragging PDF files from a Folder.

I closed the Database, and then reopened it and the PDFs were not available any more. IE. WHen I tried to double click on them, they did not open Acrobat Viewer.

I put another 15 PDFs into the DB using the exact same method. Dragging PDF files from a folder. These files (after closing and opening the DB several times) are available, upon double click, they bring up Acrobat Viewer.

The size of the database indicates that the PDF files of the first 110 records are somehow included in the database, but are no accessible as far as I can tell.

Another difference is the icon representing the Adobe file in the container field. IN the records that are accessible, the icon is very small, and just says, "Adobe Document", whereas, the unaccessible documents have a much bigger icon, and the name of the file beneath the icon.

Any help would be good, since if I can't solve this, I'll be here all night.

I can't offer any assistance, but I would sure like to know how you resolved this.

I had a similar problem before. I solved it by making a script 'Flush Cache to Disk'

I think that you have created links to the documents you can open and put the documents that you can't open in the container field.

At least, I think that's how it works: as long as the document is only linked to, a double-click will cause Windows to open it with the associated program, if it is in the FM db itself, it's just a chunk of binary that FM can store, but can't open.