Quote:Three things come to mind:
1. Are you copying both the db AND the dat files to the server from your workstation?
2. Are you sure you are working with the same exact revision of Sesame on the server and your workstation?
3. Are you making sure that the application you are working on, is not still loaded in Sesame Server when you copy the files from the workstation to the server machine?
Yes to all three questions. I have been very careful.
Here's an update:
The problem started after I imported my Workorders from Q&A, 25,219 records.
Here's what I've tested, and the results:
Remove all Workorder records from Sesame app (-25,219 records): File opens.
Remove just the COD records (in case the import from text to money wasn't as clean as I thought), leaving all others (-531 records): File will not open.
Remove all COD's and all records prior to 2007 creation date (-23,536 records) : File opens.
Remove all COD's and all records prior to 2006 (-21,856 records): File opens.
Remove all COD's and all records prior to 2005 (-20,006 records): File opens.
That's where I am at the moment, still working backwards trying to see how much data can be retained and still have the file open.
One thing I should mention: after I copy the edited file to the server and try to open it with Sesame client, it takes just a few seconds for the "Loading" process to complete, but about 40 minutes for the "Saving" process to complete. Not sure what that means.