I'm currently trying to debug an issue with a legacy system at my company. The original project was developed in the mid 90's, and everyone who knew the system has left the company. Currently we're seeing an error with one of the .DBF files, a simple table that holds no more than 4-5 columns, and barely any rows. The message the system is sending us is that we cannot open Message.dbf in Shared Mode.
Is there a way to open the database in an exclusive mode? We have a system with DBFManager and a Visual FoxPro 6.0 set up. Any hints, or links to information on these types of databases would be helpful. We have nobody with knowledge of these systems. I wish I could provide more detailed information, but I'm at a loss here.
So far we've tried replacing the file with several backups we had on the system, and restarting the server the .DBF file was located in (In case of a lock issue). So far nothing has solved the issue.
We weren't able to debug exactly what the issue with opening the .dbf file was. In stead, we found a backup of the system that was several weeks old, and were able to restore the entire system to that state. The program is currently working fine, though we were unable to find the cause of the issue originally.