I have a .mdb file in c:\mydir\ i need to copy in \\server1\dir\ i used file copy and other command but the time of trasfering file is very very big!!!!
Have other solution???
note:
I need to use VBA for excel code in this project.
Printable View
I have a .mdb file in c:\mydir\ i need to copy in \\server1\dir\ i used file copy and other command but the time of trasfering file is very very big!!!!
Have other solution???
note:
I need to use VBA for excel code in this project.
How large is the file?
How long does it take?
What speed is the network?
How much traffic is on the network?
To give you an idea I have a Gigabit network here with very little traffic If I copy a file of 800 megs over the network from a PC with a gigabit card to a pc with a gigabit card it takes about 30 seconds. If I transfer the same file to a PC with a 10/100 network card it takes about 2 minutes. If I were to transfer to a PC with a 10mb card it would take about 10 minutes or so. If I were to transfer it wirelessly using an 802.11 connection it could take an hour or more. If the 802.11 was A, B G N it would be progressively faster based on the mode and signal strength of the connection
So if you are on a network at work where several people are using it and you have 10/100 switch gear or a 10/100 card in either PC used for the file copy this could be the source of the slowness. Upgrade hardware is the simple but not so cheap solution.
If you are using a wireless connection then there are a few other potential things to consider. The mode you are connected in and the signal strength of your connection. A weak signal can cause the transfer to be very slow.
I am using Robocopy to copy/move files and it is faster compared to the windows copy but I've stumbled on this forum this utility called FastCopy which looks to be faster than Robocopy so you may want to try it.
I friend...
the point 6 on the web suggest this command lne:
fastopy.exe C:\Windows "C:\Program Files" /to="D:\Backup Folder\"
is this correct to use in vb6 classic?
But the exe file is a part of installation of programm?
if yes, i cannot install any programm on my Office Pc, have a limitation from the Admin:-(
i think, if i installa the programm on my Home Pc and get only the exe file and copy in c:\temp\ of my Office pc how to call the exe from this dir and execute the code?
sorry me...