transferdatabase

[gil]

I link table from an other access database by : docmd.transferdatabase
aclink, ...

in access 2003 it is very long, when i use on the same computer 2000 it is
very fast why ?

The both base are in access 2003
the Subdatasheet Name property are set to none
The disk format is NTFS
short name are used for both database

thanks for help

 

[steve]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Steve

 

[Guest]

Try to go to tools> Database utilities> Compact and repair Database. Try and
see if that speeds up the 2003 Database. Do it to both databases.