I wrote:
-------------------------------
As I understand it, Network Optimize copies over forms, indices, etc. to a shadow folder. It also makes a local table whose only entry is a pointer to the "server" table. That works for me. Refreshing this new shadow database after updating forms or indices etc. copies them over again so the "client" has the current version of them. My problem (reported earlier in a thread called "Problems With Forms" or something like that) was that once the form was copied over, it was broken. I was able to work around it by manually coping the files (muf, cdx, and the rest - 9 total) from the "server" to the "clients" shadow directory. My new problem is that I have created an index in this database. It is just the Last Name field. Now searching on the "server" machine is much faster. Using "Find by Key" is asks for Last name and hurries right along. Refreshing the shadow databases to copy this all over to the "client" (I also tried deleting everything on the client and doing a new Network Optimize) should have copied this index over. However, it didn't. Find by Key still asks for the default "record number". I tried my previous work-around (manually bringing the files over), but it didn't help this time. Any thoughts? Thanks again everyone. Sean
Tom Cone Jr wrote:
-------------------------------
Sean, I think you're headed for trouble if you manually copy tables and indexes from the server to your shadow folder and then run the app against them there. If Alpha Five opens a live table in your shadow folder and your user makes changes, they will not be recorded in the corresponding tables on the server.
Sometimes the terminology gets in the way.
Assume the workstation has its own copy of Alpha Five (the program files).
Assume the workstation has 'mapped' the folder on the server where the data resides to a local drive letter, and that this mapping is the same throughout all workstations. i.e. they all see the server's data folder as Drive Y: or whatever.
If you start A5 on the workstation, and then open the database on the server (in drive Y:, for example) you could then 'network optimize' the database. This process will build shadow copies of your data tables in a folder on your local workstation. It will also copy all the supporting and ancillary files, ....
My Reply:
-------------------------------
Alpha Five is installed on the workstations. I didn�t copy tables. The table still resides on the �server�. The only table on the clients is the shadow one (containing one entry, a pointer to the �server� table). Network Optimize copies a set of files (looks like everything except the DBF �tables�) to the �client� machine. However, those files are broken when they get there. That is, when I try to open our one form on the �client� machines, it tries to open the default form, which doesn�t display all our fields, instead of the one I designed that works fine on the �server� (for details see the thread �Problems Loading Form� from 9/14/00).
I was able to overcome the form problems by manually copying those ancillary files to the clients shadow directory. Not ideal, not the way Alpha 5 is supposed to work, but it gets me by and back to my actual job.
My new problem is that the client machines are not recognizing the index that I built for this database on the server. It looks like this in Define Indexes.
Last LNAME Ascending All
It works great on the server. If I use �Find by Key� rather than �Find Text� it prompts me for the Last field (Last Name) and when I enter Miller (or whatever) goes right to the first entry. I can then use the Next button to go through them, even to new ones that match that name that have been added since the database was last sorted (and thus are at the very end after the Z�s).
On the shadow database on the �clients� though, �Find by Key� prompts me for the record number (or whatever the default index is before you build any). Network Optimize, Refresh Shadow, and manually copying over the ancillary files � none of them helped.
Thanks Tom & everyone!
Sean
Who knows where data lurks on the network. The Shadow knows. HAHAhahahahaha
-------------------------------
As I understand it, Network Optimize copies over forms, indices, etc. to a shadow folder. It also makes a local table whose only entry is a pointer to the "server" table. That works for me. Refreshing this new shadow database after updating forms or indices etc. copies them over again so the "client" has the current version of them. My problem (reported earlier in a thread called "Problems With Forms" or something like that) was that once the form was copied over, it was broken. I was able to work around it by manually coping the files (muf, cdx, and the rest - 9 total) from the "server" to the "clients" shadow directory. My new problem is that I have created an index in this database. It is just the Last Name field. Now searching on the "server" machine is much faster. Using "Find by Key" is asks for Last name and hurries right along. Refreshing the shadow databases to copy this all over to the "client" (I also tried deleting everything on the client and doing a new Network Optimize) should have copied this index over. However, it didn't. Find by Key still asks for the default "record number". I tried my previous work-around (manually bringing the files over), but it didn't help this time. Any thoughts? Thanks again everyone. Sean
Tom Cone Jr wrote:
-------------------------------
Sean, I think you're headed for trouble if you manually copy tables and indexes from the server to your shadow folder and then run the app against them there. If Alpha Five opens a live table in your shadow folder and your user makes changes, they will not be recorded in the corresponding tables on the server.
Sometimes the terminology gets in the way.
Assume the workstation has its own copy of Alpha Five (the program files).
Assume the workstation has 'mapped' the folder on the server where the data resides to a local drive letter, and that this mapping is the same throughout all workstations. i.e. they all see the server's data folder as Drive Y: or whatever.
If you start A5 on the workstation, and then open the database on the server (in drive Y:, for example) you could then 'network optimize' the database. This process will build shadow copies of your data tables in a folder on your local workstation. It will also copy all the supporting and ancillary files, ....
My Reply:
-------------------------------
Alpha Five is installed on the workstations. I didn�t copy tables. The table still resides on the �server�. The only table on the clients is the shadow one (containing one entry, a pointer to the �server� table). Network Optimize copies a set of files (looks like everything except the DBF �tables�) to the �client� machine. However, those files are broken when they get there. That is, when I try to open our one form on the �client� machines, it tries to open the default form, which doesn�t display all our fields, instead of the one I designed that works fine on the �server� (for details see the thread �Problems Loading Form� from 9/14/00).
I was able to overcome the form problems by manually copying those ancillary files to the clients shadow directory. Not ideal, not the way Alpha 5 is supposed to work, but it gets me by and back to my actual job.
My new problem is that the client machines are not recognizing the index that I built for this database on the server. It looks like this in Define Indexes.
Last LNAME Ascending All
It works great on the server. If I use �Find by Key� rather than �Find Text� it prompts me for the Last field (Last Name) and when I enter Miller (or whatever) goes right to the first entry. I can then use the Next button to go through them, even to new ones that match that name that have been added since the database was last sorted (and thus are at the very end after the Z�s).
On the shadow database on the �clients� though, �Find by Key� prompts me for the record number (or whatever the default index is before you build any). Network Optimize, Refresh Shadow, and manually copying over the ancillary files � none of them helped.
Thanks Tom & everyone!
Sean
Who knows where data lurks on the network. The Shadow knows. HAHAhahahahaha
Comment