To add to Marks suggestion. What I've done is write a prg that opens the database exclusively and issues the appropriate ALTER TABLE commands. Add the prg to a project and create an EXE to take to the client. Run the EXE to change the tables on the clients machine and then copy your new EXE upgrade to the machine.
>My users wanted some upgrades made to a vfp EXE I coded for them. The upgrade included some field length changes in some of the tables. The tables are in a Database. Is there a way I can append the old Database to the new upgraded Database so my users can retain their old data?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.