.DBF File not opening properly when clicked in Windows Explorer

[foxlover2012]

Hi all,
Does anyone know how to fix my problem? When I double click on a .dbf from Windows Explorer, VFP opens the file, but not as browse. VFP opens the file in a command window (like modify file does) and of course that is not acceptable. I'm using VFP 9 SP2 and Window's vista. The problem started last week after installing open office. Does the same thing for other file types types such as .SCT.
I prefer not to reinstall VFP, but that may be my only option.
Thanks John

 

[Mike Lewis]

In the first instance, try running VFP with /regserver in the command line.

In other words, do this from a command prompt:

c:\program files\vfp9\vfp9.exe /regserver

Substitute the correct path name for your system.

If that doesn't solve the problem, report back.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[foxlover2012]

Thanks for your help.
This did not work. The program ran but did not seem to make much difference. I rebooted after.
Now when I double click on .dbf, VFP starts and brings up the open table window just like you had issued USE ?.
However when you select any .dbf from the open dialog box, it returns message "record out of range". Any other ideas?

 

[Mike Lewis]

OK, the next step is to check your file associations. Follow these steps (the actual wording of the menus and prompts might be slightly different on your system):

1. In Windows Explorer, go to Tools / Folder Options / File Types.

2. Scroll down the Registered File Types list and select DBF (in the left-hand column).

3. Click Advanced, then Open, then Edit.

You should see something like this in the "Application used to perform action" box:

"C:\Program Files\VFP9\vfp9.exe" -SHELLOPEN "%1"

If you don't, edit the box so that you see the above line (including the double-quotes), but change the path as necessary to match the actual path to your VFP directory.

Then OK out of all the open dialogues.

If that still doesn't work, you might need to fall back on a re-install. But don't go that far until we are sure.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[foxlover2012]

Thanks so much!!
Since I am using Vista, the File Types tab is not available.
However I was able to download a little utility called FileTypesMan that gave access to all file extensions and options.

Thanks again.

 

[Mike Lewis]

I was able to download a little utility called FileTypesMan that gave access to all file extensions and options.

So, are you saying that the problem is now solved?

Mike




__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[foxlover2012]

Yes, it is working perfectly for all file types now. I was able to use the downloaded utility to add "-SHELLOPEN" to the line.
Thanks for your help in solving the issue! John

 

[Mike Lewis]

Glad to hear it's working, John.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy