Myself and one other person run a small 'business' where we are using Filemaker Pro 12.
Up until now everything has been fine, but this morning i noticed that approximately 1/3(500) of the dates within one tables records had automatically changed format.
From dd/mm/yyyy to mm//dd//yyyy.
I can easily fix this problem by just exporting the data , and using a program to automatically fix it, then re-import the data but. My big worry is, why has it happened? i have a basic knowledge of how a database works. But not enough to know why this has happened. Is the database corrupt?
P.S i read somewhere earlier that the maximum file size a database should be is 2gb? My current one is at 13.33GB....most likely due to the number of images? 2500+ within container fields.
File size: 13.33GB
Total of : 2400 Records, 9 Tables, 24 Layouts
1400 Records in the table with errors.
Containers Stored at : [database location]/Files/Final Duran Duran Database/
Stored On:Mac Book Pro(Retina)......OS X 10.8.4..... 2.3Ghz Intel Core I7 .....8GB 1600Mhz DDR3
Thank you in advance ,