Problem:
Slow opening (approx 60 sec) of an Access Database form (in design mode only) from NT 4 sp6a workstation when database is on a network server. All other aspects of database (i.e. table, forms) worked fine – only DESIGN mode was slow.
Investigation:
Via testing it was determined that the problem was related to the NT SP level of the workstation and server. If the wks was SP 6a and the Server was SP 4 or 3 (not tested on other SP levels) then the problem would occur. If Server was upgraded to SP6a then problem stopped. This was repeatable and confirmed on various wks/server combinations. Note: this did not happen in reverse: if the Wks was SP4 and server was SP6a, then all was OK. Also: Install of Office SR1 had no impact
Question:
Has anyone else seen this? if so, what may be the actual technical reason for the problem? Obvious solution is to upgraded servers to SP6a, but I would like to know what is happening and possibly if there is another solution such as reghack
Thanks!