Sign in with
Sign up | Sign in
Your question

Can’t open my database files of Visual FoxPro

Tags:
  • How To
  • Database
  • Apps
Last response: in Apps General Discussion
Share
August 31, 2012 10:41:46 AM

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. :( 

More about : open database files visual foxpro

Related resources
September 1, 2012 7:41:10 AM

koumotodragon said:
hi

What is this "hi"? I'm not here for introducing myself.
And what's that link? :fou: 
If you can do something related to my issue then help me otherwise......!
m
0
l
September 1, 2012 7:49:46 AM

CGW said:
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. :) 
m
0
l
September 1, 2012 7:58:14 AM

Is it safe to import the data and file objects from old database file to a new one? My database is very large in size.
m
0
l
September 3, 2012 4:29:57 AM

CGW said:
Don't worry. It is safe but however make a backup again for that database file.
Just visit this page http://support.microsoft.com/kb/168762
Hope it will help you. :) 

I tried it but still the problem is "on" with my database file........anything more you can see here?
m
0
l
September 4, 2012 8:31:08 AM

CGW said:
You need to use a software recovery application. I read about one, here is the link of an article: http://www.articlesbase.com/data-recovery-articles/best-way-to-deal-with-database-file-corruption-5885277.html
You must read this article before go for any application. ;) 
Hope you'll get what you are looking for. :) 

Thanks for sharing this article with me. SysInfoTools DBF Repair worked nicely. I never could fix this if I didn't read this one.
Thanks a lot!!!!!!!!!!
:bounce: 
m
0
l
September 4, 2012 8:33:06 AM

Best answer selected by Riallie.
m
0
l
!