Slow opening of Access table in Project

[Dave]

I have a fairly large Access table (~ 20K rows, 20 columns) that I
open in Project03 employing the FileOpen method in VBA running in
Access. It takes an hour or more to open this table.

SInce the process runs daily, I'd like to speed it up. Can anybody
suggest a faster way of getting this data into Project? The process in
question is entirely automated and runs on a server as a scheduled
task.

Thanks
Dave

 

[Rod Gill]

If you manually open the project from Access how long does it take?

If you use File, save as to save back to the database how long does it take?

If you re-open from the saved copy how long does it take?

If you save the opened file as a .mpp file how long does it take to open?

If you save the opened file as xml then close and re-open how long does it
take to re-open?

This information might indicate where the problem lies.



--

Rod Gill
Project MVP

Project VBA Book, for details visit:
http://www.projectvbabook.com

NEW!! Web based VBA training course delivered by me. For details visit:
http://projectservertraining.com/learning/index.aspx