FoxPro files
Microsoft Access and SQL Server both keep everything in a single, large file. FoxPro
has always spread data and programs across a number of individual files which may or
may not be in the same directory.
Broadly speaking, FoxPro files fall into three categories:
- Plain text in ASCII files
- Data in dBase format dbf files
- Binary data in various FoxPro formats
Text files
| Extension |
Contents |
| .bak |
Backup of a program file. Also used for the backup of a dbf file. |
| .err |
Project build errors. |
| .mpr |
Generated menu program. |
| .prg |
Program code. |
| .qpr |
Generated SQL query. |
| .spr |
Generated screen program (Fox 2.6 and earlier). |
| .txt |
Text. |
dbf files
FoxPro has built on the dbf format introduced in dBaseII.
| Extension |
Contents |
| .bak |
Backup of a .dbf file. Also used as the backup of a text file or program. |
| .dbf |
Data for fixed-length fields. |
| .cdx |
Compound index. |
| .fpt |
Data for memo fields, images and objects. |
| .tbk |
Backup of memo fields. |
Note that the .bak and .tbk files are only created as backups when you change the
structure of a table. They don't act as day-to-day backup of data.
Every table will have a dbf file. If it has a cdx or fpt or both then
those two or three files must reside in the same directory and you must copy
them as a set. Flags in the dbf indicate whether a cdx or fpt should be present
and you won't be able to use the dbf if these files are missing.
FoxPro also uses the dbf format to hold design information in the following files.
Each set of three extensions correspond to the .dbf, .cdx, and .fpt files above.
| Extensions |
Contents |
| .dbc, .dcx, .dct |
Database container. |
| .frx, .frt |
Report data and memo (no index). |
| .lbx, .lbt |
Label data and memo (no index). |
| .mnx, .mnt |
Menu data and memo (no index). |
| .pjx, .pjt |
Project data and memo (no index). |
| .scx, .sct |
Form (or screen) data and memo (no index). |
| .vcx, .vct |
Class library data and memo (no index). |
Binary data
| Extension |
Contents |
| .fxp |
Compiled program. |
| .mpx |
Compiled menu program. |
| .spx |
Compiled screen program (Fox 2.6 and earlier). |
More detail
FoxPro Help has full details of these files and their structure. Type "help file
structures" into the Command Window.
|
Access 2007 has new file extensions.
Read More
|
|
