>Hi Ed,
>
>Makes sense...goes to show you can learn alot just from reading these postings, I for one have benefitted greatly.
>
>One final note:
>I run a system that numerous apps access data on a main server, with 3 main directories of data. I have a backup server that is continually updated ( every 60 seconds) with current data from the main server...a mirror image of the main server directories.
>
>All my workstations run the apps which are on the main server which are also mirrored on the backup server. All the apps startup by reading a mem file to get the paths of the data. The mem files are in the root of the server and in the root of the backup server. The backup servers mem file points (paths) to the backup data.
>
>Why:
>
>1. If the main server fails all my workstations simply run the backup apps on the backup server.
>
>2. Both main server apps and backup server apps are identical, no need for me to have different versions.
>
>3. No need for me to modify any app when a failure occurs I simply run the backup.
>
>4. When I modify a app the new version is immediatley updated on the backup server.
>
>5. No down time.
>
>Now the question I will explore is can I accomplish this by modifying the DE on my forms???
>
I think you can do this, just create some oApp.Mainserver property which is .T. if main server using and .F. for backup server, and then slightly modify DE setting method:
If oApp.Mainserver
Thisform.SetAll("Database",oApp.Mainserverpath+oApp.dbcname,"Cursor")
Else
Thisform.SetAll("Database",oApp.Backserverpath+oApp.dbcname,"Cursor")
Endif
Edward Pikman
Independent Consultant