TransferDatabase acImport too slow

[FinalPrime]

DoCmd.TransferDatabase acImport

Once the password is accepted, my
application replaces objects if needed.

The Transer is so slow, I must limit the
number of objects replaced to just a few.
Any clues on how to find the problem?

Windows XP, Office 2000, over a network, 40 users.


-example of actual code should coding be the problem

Do Until rP.EOF
DoCmd.DeleteObject acModule, rP!Object
DoCmd.TransferDatabase acImport, "Microsoft Access", "K:\MyFolder\SomeDataBases\ObjectFile.mdb", _
acModule, rP!Object, rP!Object
rP.movenext
loop


thanks,
FinalPrime

 

[dhulbert]

First ting I would do is to move it all to a local hard drive and try it then you can eliminate any network speed issues
Then start looking at the objects you are deleting, how big are they do they take a long time to delete.
Try doing a compant and repair on th edatabase and see if that speeds things up a bit

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[FinalPrime]

Douglas,

Over network:
delete time < 1 second
import time +- 9 seconds
for Modules ; size has no affect
for Forms: smaller sizes take slightly less time.

Locally:
Process cut down by 20%.
++++++++++++++
In sum, small-or-large and network-or-Locally,
no significant difference.
++++++++++++++++++++
With that info, expected wait time to replace an object is 10 seconds.

So ( at 10 sec per object), user will wait one minute
if six objects are to be replaced.
++++++++++++++++++++++++====
The application does a compact and repair at signoff.
++++++++++++++++++++++===

finalprime