>>Hi everybody,
>>
>>I'm working on DataEntry application at this moment. One of the regimes is "Download new version of Lookup tables". These tables are part of Lookups database and only few really change.
>>
>>So, somebody will put these two or free tables in Download directory of DataEntry. These tables have a link to a DataBase. I guess, I can not just copy tables from this directory to Lookups directory, because I would have problems with links.
>>
>>One solution would be to open old table exclusively, zap and append from the new (if I would be able to open it without its Database). I'm wondering, is there another "back door" way? Fixing database on the fly (with low-level functions)?
>>
>>Appreciate your guidance.
>
>Hi Nadya,
>
>You might try to open both tables, SCAN through the new source table and go through the target table completely replacing the records one-by-one with SCATTER/GATHER. New lookup tables typically contain more records, however if the target table will have more records than the new source you may just delete the rest.
>This way you will reuse the existing amount of records.
Hi Nick,
I've ran a test. I just copied file from one place to another and was able to open table just fine. May be I was incorrect in my original assumption, that it should not work this way... I'll run more tests on Monday to be sure, that simple copy works...
BTW, did you talk with Michel about the problem, we discovered yesterday with Account Setup?
If it's not broken, fix it until it is.
My Blog