DoCmd.TransferDatabase performance in Access 2003

D

Descalle

Hi,

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TransferDatabase slow performance in Access 2003 1
Performance question? 3
migration performance question 8
security warning in access 2007 copying query with doCmd.transferdatabase 0
linking tables from pw protected MDB 0
access2003/sqlserver2005 performance issue 6
File Structure and Performance 5
Sluggish performance 4

Top