F
fernando
Hi,
There are 3 excel files (on 3 different computers) working at the same time that read/write to a common access file (on a 4th computer) through a regular network. The excel file reads a recordset (example: 2000 records / 15 fields) and write it to a hidden sheet from were it has "local" access. Would it be more recommendable to have these files make querys reading only the desired information?, eventhough each file would make one query every 2 minutes aprox.?
Thanks in advance
There are 3 excel files (on 3 different computers) working at the same time that read/write to a common access file (on a 4th computer) through a regular network. The excel file reads a recordset (example: 2000 records / 15 fields) and write it to a hidden sheet from were it has "local" access. Would it be more recommendable to have these files make querys reading only the desired information?, eventhough each file would make one query every 2 minutes aprox.?
Thanks in advance