transferDataBase slower 2003

  • Thread starter Thread starter gil
  • Start date Start date
G

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 ?

thanks for help
 
Are both file using the same file format ? I noticed that linked tables are
very slow when linking between two differents file formats...
 
yes all the database are in access 2003 format


Patrice said:
Are both file using the same file format ? I noticed that linked tables
are very slow when linking between two differents file formats...
Click to expand...
 
Is this just this particular statement that is slow ? (was thinking about
articles such as
http://support.microsoft.com/kb/275085/en-us?spid=2509&sid=49 that you can
find by googling "linked table" slow at support.microsoft.com).

I would also try to create a new file in which I would populate a dummy
table. I woudl then create another new file in whihc I would attach the
former table. This is to try to find out is this behavior occurs with
particular files or if this is a machine wide problem...

Good luck.
 
Back
Top