Database


#1

In Windows Explorer, when I double click on a dbf file (of form .dbf), instead of opening the file in VFP, I get a message “.fxp is not an object file”.

e.g. clicking on T_DCLNT.DBF, gives message “t_dclnt.fxp is not an object file”.
Anyone else having this issue?


#2

Well, a DBF file is a “DataBase File” and therefore can only be opened using a database program that can read
that one filetype. Now, as “defined”, .DBF files are:

DBF files were originally used in dBase II and continued through to dBase Version IV. The DBF file format originated by Ashton-Tate, but is understood by Act!, Clipper,FoxPro, Arago, Wordtech, xBase, and similar database ordatabase-related products. DBF files can also be opened by Microsoft Excel and Microsoft Access.
So, first, you need one of the above programs installed on your system. Next, you need the file extension of .DBF to be attached to that program.

To explain a little further, all files have extensions. All files have a program that can open them. Some can be
opened by various programs. Such as .TXT or TEXT files can be opened with Notepad, Wordpad, MS-Word,
etc… DBF files need a database program installed that can open them. You can download the Microsoft
Visual Programming Suite for free which includes MS-Access which is a good program for DBF files…

Hope that helps


#3

For additional information click the following link: https://www.fixtoolbox.com/dbffix.html
DBF Fix Toolbox

Also you can try to follow these steps:

  1. Click on Start and then Control Panel.

  2. Click on the Programs link.

    Note: If you’re viewing the Small icons or Large icons view of Control Panel, you won’t see this link. Click on the Default Programs icon and then click on the Associate a file type or protocol with a program link. Then proceed to Step 4.

  3. Click on the Make a file type always open in a specific program link under the Default Programs heading

  4. In the Set Associations window, scroll down the list until you see the file extension that you want to change the default program for.

  5. Click on the file extension to highlight it, once you’ve found the one you’re looking for.

  6. Click the Change program… button above the scroll bar.

    The Open With dialog box should appear.

  7. Look through the options in the Recommended Programs area and choose the application that you want to open the file extension with when you double-click on the particular kind of file on your computer.

    Note: Chances are, the applications listed under Recommended Programs will contain the most applicable programs for this file type but be sure to look at the applications under Other Programs. You may need to click the v to expand the list of these programs.

    Note: Click Browse… to search through your computer for any program not listed that you’d like to use.

  8. Click the OK button on the Open With window. Windows 7 will refresh the list of file associations to show the new default program to open this type of file.

  9. Click the Close button at the bottom of the Set Associations window. You may also close the Control Panel window if it’s still open.

  10. From this point forward, when you double-click on any file with this particular file extension, the program you associated it with in Step 7 will launch and load the particular file.

    Important: Whatever program used to automatically open when these types of files were launched will still open these types of files. To use another program, you’ll just need to start the program manually and then browse your computer for the particular file.