I have been using Visual FoxPro from last two years. I’m working as database administrator. But I never ever faced such a situation in my past what I got last night. I was working on a database file from last few months but last night (I was on night-shift) I couldn’t open my file. An error popped up telling me that something wrong with my database’s index. My database file is around 64 MB and it really contains lots of data which shouldn’t be missed anyhow. I really don’t know how to troubleshoot it. Please help.
As you said that you are a database administrator then you must have backed up your database files. If you have a valid and updated backup just restore that database file from it. But if not then you need to do this: just create a new database file and import all the data and file objects from the old one to new one.
Hope it will for you.
It can be said my bad luck as my back up is unable to restore that database file.
"Importing all the data and file objects from old one to new one" sounds good. Can you tell me how to do this? Your work will be really appreciated.