>>>I wrote vfp50 program for my users.
>>>One of the dbfs I am using is called rate.dbf.
>>>Every year, a new rate.dbf comes out. I need
>>>to let the users update the rate.dbf file in the program.
>>>any ideas?
>>
>>Are you saying that you include the .dbf in the .exe? If so (not that I think that this is a good idea), you need to recompile and give them the new executable. If the users have a copy of the table, just have them copy the new table over the old one.
>>Or are you trying to further automate the process? If so, please specify how automated you want it to be.
>Hi Erik
>Yes, I want to further automate the process. I want the users to put
>in the disk with the new rate.dbf on it and then pick an option
>off the menu like UPDATE RATE TABLE. Then, the new file is copied over
>the old one.

Just add a new menu item that runs a procedure. Use the COPY FILE command:

oldsafe = set('safety')
copy file 'a:\newtable.dbf' to 'c:\mypath\oldfile.dbf'
set safety &oldsafe

If the location on the drive is not always the same, use the putfile() dialog and use the location returned by this function.