(Excuse my english, i’m spanish )
The situation:
-
I have a local network (workgroup) of 4 computers (W2000 Prof+SP4+patches. and WXP Prof.+SP2+patches)
-
My computer with Avast 4.6.691 Professional (options by default) and WXP Prof.+SP2+patches
-
In my computer i have shared a folder (example: “C:\working”)
-
In my computer i have declared a networking that is of the shared folder (example: “S” → one corresponds to the folder on my computer “C:\working”)
-
In my computer i have the Microsoft Access 2000 with one module including:
DoCmd.TransferDatabase acExport, “dBase III”, “C:\working”, acTable, “table_access_1”, “tb1”
DoCmd.TransferDatabase acExport, “dBase III”, “C:\working”, acTable, “table_access_2”, “tb2”
DoCmd.TransferDatabase acExport, “dBase III”, “C:\working”, acTable, “table_access_3”, “tb3”
DoCmd.TransferDatabase acExport, “dBase III”, “C:\working”, acTable, “table_access_4”, “tb4”
DoCmd.TransferDatabase acExport, “dBase III”, “C:\working”, acTable, “table_access_5”, “tb5”
DoCmd.TransferDatabase acExport, “dBase III”, “C:\working”, acTable, “table_access_6”, “tb6”
The program Access it works correctly (fast), single it takes 2 seconds aprox.
BUT the same example with connection to the unit “S”, the icon of the Avast gives returns (tour) while the lines of the Access are executed and it takes approximately 15 seconds ???
DoCmd.TransferDatabase acExport, “dBase III”, "S:", acTable, “table_access_1”, “tb1”
DoCmd.TransferDatabase acExport, “dBase III”, "S:", acTable, “table_access_2”, “tb2”
DoCmd.TransferDatabase acExport, “dBase III”, "S:", acTable, “table_access_3”, “tb3”
DoCmd.TransferDatabase acExport, “dBase III”, "S:", acTable, “table_access_4”, “tb4”
DoCmd.TransferDatabase acExport, “dBase III”, "S:", acTable, “table_access_5”, “tb5”
DoCmd.TransferDatabase acExport, “dBase III”, "S:", acTable, “table_access_6”, “tb6”
Thanks