>Thank you for your quick response, however, I did not have access to the program at the time and was not able to give a more detailed response.
>I am a Web Developer who has used Access for a long time and had previously did a little work with Foxpro 2.6. However, I recently was given a project to convert a 2.6 foxpro program to visual basic 6.0. My question was why??? they didn't have an answer so I proceeded to do an upgrade. Now, any time I try to update the database, i get a cannot update cursor. If I run the code (I.e. I don't complie it, i hit the exclamation point (Run (CTRL + E))), It runs fine, but when I complie the EXE, the prog fails... Here is the code:
>
>-----------BEGIN--------------saveset.prg---------------------
>=packit('setup')
>=packit('setchem')
>=packit('chemical')
>=packit('riskexp')
>=packit('default')
>-----------END--------------saveset.prg---------------------
>
>
>-----------BEGIN--------------packit.prg---------------------
>PARAMETER whichdbf
>
>CLOSE ALL
>
>WAIT 'Packing ' + whichdbf WINDOW NOWAIT
>
>USE &whichdbf
>EDIT FIELDS
>PACK
>USE
>
>RETURN
>-----------END--------------packit.prg---------------------

PACK requires a table to be opened exclusive. However, that would probably not give you 'Cannot Update Cursor' errors.

Also, on a side note, in VFP if you intend to distribute as an exe you should always test your code compiled. The design time environment can behave differently than an exe.