TransferDatabase slow performance in Access 2003

[Descalle]

Hi all,

I recently moved from Access XP to 2003. I have a frontend/backend
application where about 25 tables are linked at startup using the
TransferDatabase command.

I takes about 30 seconds in Access 2003 to link the tables, it only
took about 1 second to do the same thing in Access XP. I've spent the
last 2 days trying to find out how to improve this, and the solutions I
found so far do not bring any improvement :
- turning off name autocorrect
- making sure the link with the server mdb stays open

Any other ideas? PLEASE HELP!!

Pascal

 

[Allen Browne]

At the start of your relinking code, OpenDatabase on the back end file:

Dim dbBE As DAO.Database
Set dbBE = OpenDatabase("C:\MyPath\MyFile.mdb")

'relinking code here.

dbBE.Close
Set dbBE = Nothing

Although you don't actually use this connection, it holds the file open,
which expedites the operation.

You may also find that the length of the path is an issue. More suggestions
such as that:
http://www.granite.ab.ca/access/performancefaq.htm