Slow form display

[Alexander L via AccessMonster.com]

Using Access 2000 FE on local drive, SQL Server BE on network drive. On every PC other than mine, forms containing data open quickly. On my PC however, they can take up to 15 seconds to display. Each field slowly appears, individually.

I recently received a new PC, and this problem wasn't on the previous. Is there some setting I missed?

Thanks,
Alex

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=0d0bd6e998d4407ab155ba96a41fff88
*****************************************

 

[Alexander L via AccessMonster.com]

Windows 2000 SP4, msjet40.dll version 4.0.08618.0

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/uwe/Forum.aspx/access-setupconfig/3129
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=b473b92c0d3849da9312e8d807e11f78
*****************************************

 

[Alexander L via AccessMonster.com]

ok, i've isolated the problem. the following two areas cause slowdowns:

1. in VBA, with any openrecord function call. ie.
sSQL = "SELECT UserName FROM tblName WHERE [UserID] = 1"

Set db = DBEngine(0)(0)
Set rst = db.OpenRecordset(sSQL, dbOpenForwardOnly) <--- slow

2. when a form with a recordsource is being displayed, and there are combo boxes that have 2 columns (1 ID, 1 value). the recordSource is simple (ex: "SELECT field1, field 2 FROM tblName"), and without one, the form opens instantly.

again, these only cause problems on my PC, not on anyone elses. any help would be greater appreciated. thanks,
alex

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/uwe/Forum.aspx/access-setupconfig/3129
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=ea6deccd7d4d48eeb12f4b6672473b65
*****************************************