Hi Deb.

Sorry for the delay in my reply -- I was at a conference and haven't been on the UT for more than a week.

>What is the recommended way of managing tables and database containers in a vfp project using sourcesafe?

I don't have a lot of experience doing that, so hopefully someone else can answer your question

>What is the best way of updating table structures without losing data in a multi client application?

I'm biased, of course, but Stonefield Database Toolkit (SDT) is the best way to handle this.

>If I need to make a table structure change to the employee table and the employee table is attached to the client dbc and every cleint has an employee tablae with their own employee data, what is the best way to update all my table structures without losing any data?

SDT can easily handle this -- you simply go through each of the subdirectories and call the Update method. For example, say you have a table called DIRECTORIES that contains the directory for each client's data. Here's some code that would update the structures of all tables in all client subdirectories:

oMeta = newobject('DBCXMgr', 'DBCXMgr.vcx')
use DIRECTORIES
scan
  lcDirectory = trim(DIRECTORY)
  open database (lcDirectory + 'MYDATABASE')
  oMeta.SetDatabase(dbc())
  if not oMeta.oSDTMgr.Update('All')
    messagebox('Could not update ' + oMeta.oSDTMgr.cAlias)
    exit
  endif
  close database
endscan

Doug