Hello access friends,
(Originally posted on access.formspro gramming which I think was the
wrong place)
I'm precalculating a bunch of data for my clients as per a profile I
have for each of them. Each data set that I generate, I put into an
separate Access file which I eventually move to a server location that
the particular client and I share access to.
Currently there are 10 clients, but this is expected to go up
considerable, and each of the precalculated data sets requires 25-30
minutes to generate (200+ Mb files). I have a form which does a batch
process to generate all of the files locally and then I go through the
files and manually post them up to the servers spaces.
What I'd like to do is include the manual moving of the files to the
server locations in the batch process however I have found that it is
quicker to do it manually because the code has to wait until it has
sent each file before continuing with the next batch item.
Anyone know how to just start transferring and move on to the next
record to start precalculating the next file before the file transfer
is complete?
The file transfer can take 30+ minutes depending on the location (some
are in Asia) and so its entirely possible that multiple files could be
transferring at the same time (when I do this manually this obviously
happens because all the file are ready to go).
I have been playing around with the following code:
Sub transfer(str_fi le As String, str_dest_locati on As String)
Dim fs As Variant
Set fs = CreateObject("S cripting.FileSy stemObject")
fs.MoveFile str_file, str_dest_locati on
Set fs = Nothing
End Sub
Sub call_test()
Dim a As String
Dim b As String
a = "\\xxx-fs01\ClientLoca tion\TESTFile.x ls"
b = "C:\Temp\TEST\T ESTFile.xls"
Call transfer(b, a)
End Sub
My thinking is that I could either:
- cause another form, instance of access or an excel application to
load for each transfer which independently initiates the transfer
although I'm not convinced that pause in the code would go away.
- use a different method which I'm unaware of
Any ideas? 6 2117
On 14 Oct 2006 03:58:42 -0700, "Mat N" <Ma******@gmail .comwrote:
Indeed a second instance of Access would do it.
So would a simple batch file spawned by the Shell command.
-Tom.
>Hello access friends,
(Originally posted on access.formspro gramming which I think was the wrong place)
I'm precalculating a bunch of data for my clients as per a profile I have for each of them. Each data set that I generate, I put into an separate Access file which I eventually move to a server location that the particular client and I share access to.
Currently there are 10 clients, but this is expected to go up considerable , and each of the precalculated data sets requires 25-30 minutes to generate (200+ Mb files). I have a form which does a batch process to generate all of the files locally and then I go through the files and manually post them up to the servers spaces.
What I'd like to do is include the manual moving of the files to the server locations in the batch process however I have found that it is quicker to do it manually because the code has to wait until it has sent each file before continuing with the next batch item.
Anyone know how to just start transferring and move on to the next record to start precalculating the next file before the file transfer is complete?
The file transfer can take 30+ minutes depending on the location (some are in Asia) and so its entirely possible that multiple files could be transferring at the same time (when I do this manually this obviously happens because all the file are ready to go).
I have been playing around with the following code:
Sub transfer(str_fi le As String, str_dest_locati on As String) Dim fs As Variant
Set fs = CreateObject("S cripting.FileSy stemObject") fs.MoveFile str_file, str_dest_locati on Set fs = Nothing
End Sub
Sub call_test() Dim a As String Dim b As String
a = "\\xxx-fs01\ClientLoca tion\TESTFile.x ls" b = "C:\Temp\TEST\T ESTFile.xls"
Call transfer(b, a)
End Sub
My thinking is that I could either: - cause another form, instance of access or an excel application to load for each transfer which independently initiates the transfer although I'm not convinced that pause in the code would go away. - use a different method which I'm unaware of
Any ideas?
Ooo...that's good. Bat file is a lot simpler. I'll give it a go and let
you know thanks.
Mat N
Tom van Stiphout wrote:
On 14 Oct 2006 03:58:42 -0700, "Mat N" <Ma******@gmail .comwrote:
Indeed a second instance of Access would do it.
So would a simple batch file spawned by the Shell command.
-Tom.
Hello access friends,
(Originally posted on access.formspro gramming which I think was the
wrong place)
I'm precalculating a bunch of data for my clients as per a profile I
have for each of them. Each data set that I generate, I put into an
separate Access file which I eventually move to a server location that
the particular client and I share access to.
Currently there are 10 clients, but this is expected to go up
considerable, and each of the precalculated data sets requires 25-30
minutes to generate (200+ Mb files). I have a form which does a batch
process to generate all of the files locally and then I go through the
files and manually post them up to the servers spaces.
What I'd like to do is include the manual moving of the files to the
server locations in the batch process however I have found that it is
quicker to do it manually because the code has to wait until it has
sent each file before continuing with the next batch item.
Anyone know how to just start transferring and move on to the next
record to start precalculating the next file before the file transfer
is complete?
The file transfer can take 30+ minutes depending on the location (some
are in Asia) and so its entirely possible that multiple files could be
transferring at the same time (when I do this manually this obviously
happens because all the file are ready to go).
I have been playing around with the following code:
Sub transfer(str_fi le As String, str_dest_locati on As String)
Dim fs As Variant
Set fs = CreateObject("S cripting.FileSy stemObject")
fs.MoveFile str_file, str_dest_locati on
Set fs = Nothing
End Sub
Sub call_test()
Dim a As String
Dim b As String
a = "\\xxx-fs01\ClientLoca tion\TESTFile.x ls"
b = "C:\Temp\TEST\T ESTFile.xls"
Call transfer(b, a)
End Sub
My thinking is that I could either:
- cause another form, instance of access or an excel application to
load for each transfer which independently initiates the transfer
although I'm not convinced that pause in the code would go away.
- use a different method which I'm unaware of
Any ideas?
Ooo...that's good. Bat file is a lot simpler. I'll give it a go and let
you know thanks.
Mat N
Tom van Stiphout wrote:
On 14 Oct 2006 03:58:42 -0700, "Mat N" <Ma******@gmail .comwrote:
Indeed a second instance of Access would do it.
So would a simple batch file spawned by the Shell command.
-Tom.
Hello access friends,
(Originally posted on access.formspro gramming which I think was the
wrong place)
I'm precalculating a bunch of data for my clients as per a profile I
have for each of them. Each data set that I generate, I put into an
separate Access file which I eventually move to a server location that
the particular client and I share access to.
Currently there are 10 clients, but this is expected to go up
considerable, and each of the precalculated data sets requires 25-30
minutes to generate (200+ Mb files). I have a form which does a batch
process to generate all of the files locally and then I go through the
files and manually post them up to the servers spaces.
What I'd like to do is include the manual moving of the files to the
server locations in the batch process however I have found that it is
quicker to do it manually because the code has to wait until it has
sent each file before continuing with the next batch item.
Anyone know how to just start transferring and move on to the next
record to start precalculating the next file before the file transfer
is complete?
The file transfer can take 30+ minutes depending on the location (some
are in Asia) and so its entirely possible that multiple files could be
transferring at the same time (when I do this manually this obviously
happens because all the file are ready to go).
I have been playing around with the following code:
Sub transfer(str_fi le As String, str_dest_locati on As String)
Dim fs As Variant
Set fs = CreateObject("S cripting.FileSy stemObject")
fs.MoveFile str_file, str_dest_locati on
Set fs = Nothing
End Sub
Sub call_test()
Dim a As String
Dim b As String
a = "\\xxx-fs01\ClientLoca tion\TESTFile.x ls"
b = "C:\Temp\TEST\T ESTFile.xls"
Call transfer(b, a)
End Sub
My thinking is that I could either:
- cause another form, instance of access or an excel application to
load for each transfer which independently initiates the transfer
although I'm not convinced that pause in the code would go away.
- use a different method which I'm unaware of
Any ideas?
I'm a bit rusty on the BAT file syntax so I started there and
unfortunately I don't think it is possible to refer to a server
location without a drive letter assigned to it and I don't think you
can assign a drive letter on the fly in the BAT file either (although
this is perhaps possible in VBA?).
Unfortunately as each of the server locations is a truly different
server the simplest solution would require a different drive letter to
each one however with potentially 20+ locations this would be difficult
as I might run out of letters. I would also have to rely on the IT
administrators preserving these mappings whenever they send an update
which is fairly risky.
Assigning drive letters on the fly could also be problematic because it
maybe possible for the next file transfer to initiate before the last
has completed.
Let me know if I'm misguided. I'm going to give the seperate instance
of access or excel idea a go.
Thanks
Mat N wrote:
Ooo...that's good. Bat file is a lot simpler. I'll give it a go and let
you know thanks.
Mat N
Tom van Stiphout wrote:
On 14 Oct 2006 03:58:42 -0700, "Mat N" <Ma******@gmail .comwrote:
Indeed a second instance of Access would do it.
So would a simple batch file spawned by the Shell command.
-Tom.
>Hello access friends,
>
>(Originally posted on access.formspro gramming which I think was the
>wrong place)
>
>I'm precalculating a bunch of data for my clients as per a profile I
>have for each of them. Each data set that I generate, I put into an
>separate Access file which I eventually move to a server location that
>the particular client and I share access to.
>
>
>Currently there are 10 clients, but this is expected to go up
>considerable , and each of the precalculated data sets requires 25-30
>minutes to generate (200+ Mb files). I have a form which does a batch
>process to generate all of the files locally and then I go through the
>files and manually post them up to the servers spaces.
>
>
>What I'd like to do is include the manual moving of the files to the
>server locations in the batch process however I have found that it is
>quicker to do it manually because the code has to wait until it has
>sent each file before continuing with the next batch item.
>
>
>Anyone know how to just start transferring and move on to the next
>record to start precalculating the next file before the file transfer
>is complete?
>
>
>The file transfer can take 30+ minutes depending on the location (some
>are in Asia) and so its entirely possible that multiple files could be
>transferring at the same time (when I do this manually this obviously
>happens because all the file are ready to go).
>
>
>I have been playing around with the following code:
>
>
>Sub transfer(str_fi le As String, str_dest_locati on As String)
>Dim fs As Variant
>
>
>Set fs = CreateObject("S cripting.FileSy stemObject")
>fs.MoveFile str_file, str_dest_locati on
>Set fs = Nothing
>
>
>End Sub
>
>
>Sub call_test()
>Dim a As String
>Dim b As String
>
>
>a = "\\xxx-fs01\ClientLoca tion\TESTFile.x ls"
>b = "C:\Temp\TEST\T ESTFile.xls"
>
>
>Call transfer(b, a)
>
>
>End Sub
>
>
>My thinking is that I could either:
>- cause another form, instance of access or an excel application to
>load for each transfer which independently initiates the transfer
>although I'm not convinced that pause in the code would go away.
>- use a different method which I'm unaware of
>
>
>Any ideas?
Mat,
You can assign drive letters on the fly in BAT commands using the net
use command. But you argue that this is not ideal.
For copying files, you can use the xcopy command, which allows use of
UNC paths for source or destination.
Hope this helps.
/Per
Mat N wrote:
I'm a bit rusty on the BAT file syntax so I started there and
unfortunately I don't think it is possible to refer to a server
location without a drive letter assigned to it and I don't think you
can assign a drive letter on the fly in the BAT file either (although
this is perhaps possible in VBA?).
Unfortunately as each of the server locations is a truly different
server the simplest solution would require a different drive letter to
each one however with potentially 20+ locations this would be difficult
as I might run out of letters. I would also have to rely on the IT
administrators preserving these mappings whenever they send an update
which is fairly risky.
Assigning drive letters on the fly could also be problematic because it
maybe possible for the next file transfer to initiate before the last
has completed.
Let me know if I'm misguided. I'm going to give the seperate instance
of access or excel idea a go.
Thanks
Mat N wrote:
Ooo...that's good. Bat file is a lot simpler. I'll give it a go and let
you know thanks.
Mat N
Tom van Stiphout wrote:
On 14 Oct 2006 03:58:42 -0700, "Mat N" <Ma******@gmail .comwrote:
>
Indeed a second instance of Access would do it.
So would a simple batch file spawned by the Shell command.
>
-Tom.
>
>
Hello access friends,
(Originally posted on access.formspro gramming which I think was the
wrong place)
I'm precalculating a bunch of data for my clients as per a profile I
have for each of them. Each data set that I generate, I put into an
separate Access file which I eventually move to a server location that
the particular client and I share access to.
Currently there are 10 clients, but this is expected to go up
considerable, and each of the precalculated data sets requires 25-30
minutes to generate (200+ Mb files). I have a form which does a batch
process to generate all of the files locally and then I go through the
files and manually post them up to the servers spaces.
What I'd like to do is include the manual moving of the files to the
server locations in the batch process however I have found that it is
quicker to do it manually because the code has to wait until it has
sent each file before continuing with the next batch item.
Anyone know how to just start transferring and move on to the next
record to start precalculating the next file before the file transfer
is complete?
The file transfer can take 30+ minutes depending on the location (some
are in Asia) and so its entirely possible that multiple files could be
transferring at the same time (when I do this manually this obviously
happens because all the file are ready to go).
I have been playing around with the following code:
Sub transfer(str_fi le As String, str_dest_locati on As String)
Dim fs As Variant
Set fs = CreateObject("S cripting.FileSy stemObject")
fs.MoveFile str_file, str_dest_locati on
Set fs = Nothing
End Sub
Sub call_test()
Dim a As String
Dim b As String
a = "\\xxx-fs01\ClientLoca tion\TESTFile.x ls"
b = "C:\Temp\TEST\T ESTFile.xls"
Call transfer(b, a)
End Sub
My thinking is that I could either:
- cause another form, instance of access or an excel application to
load for each transfer which independently initiates the transfer
although I'm not convinced that pause in the code would go away.
- use a different method which I'm unaware of
Any ideas?
Per,
This has been a great help thanks.
"xcopy" does indeed work with UNC Paths however I haven't been able to
get it to work with Paths which include a space. I tried quotation
marks around the pathname but without success.
Fortunately "net use" does seem to work with Paths including space so
long as you do use quotation marks. Its not ideal because I expect to
be transferring multiple files at the same time to different location
which means that I will have to create code which manages the mapping
of the drives to avoid running out of drives to map and/or
disconnecting mapped drives which should be. Nonetheless I think a net
use / xcopy combination is the best answer.
In case anyone else comes across this post I'm planning to use the
follow additional items which I hope will help avoid mapping too many
drives or removing drives which are supposed to be mapped permenantly:
Drives collection
Driveexists method
DriveLetter property
This are all in the access help.
Multitasking here we come.
Mat N
Per wrote:
Mat,
You can assign drive letters on the fly in BAT commands using the net
use command. But you argue that this is not ideal.
For copying files, you can use the xcopy command, which allows use of
UNC paths for source or destination.
Hope this helps.
/Per
Mat N wrote:
I'm a bit rusty on the BAT file syntax so I started there and
unfortunately I don't think it is possible to refer to a server
location without a drive letter assigned to it and I don't think you
can assign a drive letter on the fly in the BAT file either (although
this is perhaps possible in VBA?).
Unfortunately as each of the server locations is a truly different
server the simplest solution would require a different drive letter to
each one however with potentially 20+ locations this would be difficult
as I might run out of letters. I would also have to rely on the IT
administrators preserving these mappings whenever they send an update
which is fairly risky.
Assigning drive letters on the fly could also be problematic because it
maybe possible for the next file transfer to initiate before the last
has completed.
Let me know if I'm misguided. I'm going to give the seperate instance
of access or excel idea a go.
Thanks
Mat N wrote:
Ooo...that's good. Bat file is a lot simpler. I'll give it a go and let
you know thanks.
>
Mat N
>
Tom van Stiphout wrote:
On 14 Oct 2006 03:58:42 -0700, "Mat N" <Ma******@gmail .comwrote:
Indeed a second instance of Access would do it.
So would a simple batch file spawned by the Shell command.
-Tom.
>Hello access friends,
>
>(Originally posted on access.formspro gramming which I think was the
>wrong place)
>
>I'm precalculating a bunch of data for my clients as per a profile I
>have for each of them. Each data set that I generate, I put into an
>separate Access file which I eventually move to a server location that
>the particular client and I share access to.
>
>
>Currently there are 10 clients, but this is expected to go up
>considerable , and each of the precalculated data sets requires 25-30
>minutes to generate (200+ Mb files). I have a form which does a batch
>process to generate all of the files locally and then I go through the
>files and manually post them up to the servers spaces.
>
>
>What I'd like to do is include the manual moving of the files to the
>server locations in the batch process however I have found that it is
>quicker to do it manually because the code has to wait until it has
>sent each file before continuing with the next batch item.
>
>
>Anyone know how to just start transferring and move on to the next
>record to start precalculating the next file before the file transfer
>is complete?
>
>
>The file transfer can take 30+ minutes depending on the location (some
>are in Asia) and so its entirely possible that multiple files could be
>transferring at the same time (when I do this manually this obviously
>happens because all the file are ready to go).
>
>
>I have been playing around with the following code:
>
>
>Sub transfer(str_fi le As String, str_dest_locati on As String)
>Dim fs As Variant
>
>
>Set fs = CreateObject("S cripting.FileSy stemObject")
>fs.MoveFile str_file, str_dest_locati on
>Set fs = Nothing
>
>
>End Sub
>
>
>Sub call_test()
>Dim a As String
>Dim b As String
>
>
>a = "\\xxx-fs01\ClientLoca tion\TESTFile.x ls"
>b = "C:\Temp\TEST\T ESTFile.xls"
>
>
>Call transfer(b, a)
>
>
>End Sub
>
>
>My thinking is that I could either:
>- cause another form, instance of access or an excel application to
>load for each transfer which independently initiates the transfer
>although I'm not convinced that pause in the code would go away.
>- use a different method which I'm unaware of
>
>
>Any ideas?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Phil Frost |
last post by:
A brief introduction for python-list: Unununium is an OS being developed
in Python wherever possible. This message is phrased for the Unununium
list, but as the questions are about hacking cPython, I have CCed
python-list as well. <http://unununium.org/>
As not everyone has heard yet, the current scheduler is insufficient for
our needs. The biggest restriction is that it allocates threads in pools
of 32, which becomes a problem when we...
|
by: PeteCresswell |
last post by:
Access tends to take over my machine when I run long queries. The
queries in question are Append queries.
Some of the jobs we're talking about run 45 minutes to an hour...so
the loss in productivity is significant.
When I pop TaskManager, it looks like it's only running 10-20%
capacity - so I'm guessing the horsepower is there but other apps just
aren't getting their shots at the CPU.
|
by: Shelley |
last post by:
Hi Everyone,
Does anyone know what object it is in the MoveFile Method
object.MoveFile source, destination
in access?
Any help will be highly appreciated!
|
by: Wilfried Mestdagh |
last post by:
Hi,
After various question (here and on other places) it seems prremtive
multitasking is the way to go with .NET. But wat about coorporative
multitasking ? While this was so powerfull and easy to do in win32 ? Ok it is
still possible but it seems only with P/Invoke thing and using the old way.
But when I ask queston everyone talk to me to use threads, whil this is
normally (or was not) nececary. Even if using the non blocking things...
|
by: RSH |
last post by:
I have an ASP page that needs to move a file from one directory to another.
The code is quite simple but I can't seem to get it to work. I keep getting
a "Download Error: Procedure call or argument is not valid." error when it
hits the movefile part of the code.
What am I missing?
Dim fso = CreateObject("Scripting.FileSystemObject")
| |
by: RSH |
last post by:
I have an ASP page that needs to move a file from one directory to another.
The code is quite simple but I can't seem to get it to work. I keep getting
a "Download Error: Procedure call or argument is not valid." error when it
hits the movefile part of the code.
What am I missing?
Dim fso = CreateObject("Scripting.FileSystemObject")
|
by: b00gieman |
last post by:
Hello!
I'm using the MoveFile method for moving files between 2 servers , one running my asp script and the other running my database.My problem is that I'm getting the error:
Microsoft VBScript runtime error '800a0035'
File not found
The command for moving files:
fs.MoveFile Server.MapPath("upload/tmb2.xls"), "\\tmav035a\Test\AssetDB_test\tmb2.xls"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
| |
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |