Syntax error opening tables with VFP8

I recently got a new machine and installed VFP8 Professional. .DBF files are associated with FoxPro, but the usual icon isn't displayed in windows explorer, its the windows default icon. When I try to open the .dbf that way, I get a syntax error. I can open up FoxPro and then navigate to and open that table, but that's a pain.

I'm baffled on how to fix this, anyone have any suggestions



Answer this question

Syntax error opening tables with VFP8

  • Girishbs

    I'd say you're on the right path Dan. I'm running XP Pro with SP2. I ended up doing a full uninstall, wiping away any remnants of FoxPro on the hard drive and re-installed. I ended up getting a different error which was indicating FoxPro was trying to open the .dbfs as .fxp files. I had one of our hardware/network guys look into it further while in a meeting and he was able to fix it. I'm not sure of what exactly he did. He mentioned he changed some file associations and its working now.

    Thanks everyone for viewing this and the suggestions.


  • Ian_E

    The .dbfs are associated with FoxPro. The typical FoxPro icon is displayed there too, just not in the typical Windows Explorer windows.
  • KDX

    Something in the registry isn't connected to something it needs to be connected to.

    First step, try adding /regserver to the VFP startup command line. Start VFP. This forces VFP to write the necessary registry entries, if it (or you) has permission to do so.

    What version of Windows is this


  • fabianus

    You may check in Control Panel > Folder Options, Tab> File types: if dbf is associated with your vfp version and on Advanced button to check if you have the right icon.

  • Syntax error opening tables with VFP8