form load in accdb is slower than in mdb

[norman.b.scheinin]

Using identical databases, one in mdb format and one in accdb format, I have determined that form loading is much slower in the newer accdb format!

In one of my test scenarios, the time between Docmd.Openform and the start of code execution in the Form_Open event is 1 second for mdb and 4 seconds for accdb.

I have also determined that the accdb format is much slower when using VBA to set the ControlSource of a control or the SourceObject of a form.

Any one else experiences this? Any workarounds?

Thanks,
Norman

 

[patrick.honorez]

Have you been testing on the same machine & access version for both databases ?
Patrick