>Any thoughts? I need to write a routine that will allow a user to create a new folder somewhere on their hard drive and copy the data folder from the app also need to be able to copy it back (restore) whilst the user is in the app... I know it sounds a bit silly because most companies have a server which backs up over night etc but not this one...
>
>Also - I saw a thread in the last day or so entitled VFP V Access - can anyone post the url to it please because I am interested in the comments about VFP compared to Access...

I use DynaZip to create backups and also to unzip such backups to do a restore. This can only be done while 1 user is in the app. My backup routine closes all open forms except the backup form. Then closes any other open tables and the DBC. I then zip up the data folder and save the Zip file to a folder of the users choice using GetDir(). The filename created defaults to DTOS(date()) + '.zip' The only way to do what you want is to have exclusive access to the tables and database files.

I also have a free DynaZip class in UT downloads that servers as a wrapper to the DynaZip DLLs.