A
Al Camp
My client is getting a "calculating" indication in the status bar, and a
combo is taking 15 minutes to load. The cursor is frozen, Ctrl-Break does
not stop the "Calculating".
Eventually, the "Calculating" goes away, and the combo works well.
If the client edits any records in the table that is the source for the
combo, the
"calculating" delay occurs again.
The combo (along with 3 other exaclty similar combos) is on a continuous
subform and only contains two fields
(AttendeeID and a Last/First concatenated field), and consists of only 825
items, sorted on Last/First. The ID is indexed NoDupes and key, and
Last/First are indexed DupesOK.
There is no criteria for the combo query. There is a NoShow True/False =
True field in the query
The PC is a 2Ghz P4 with 256K of memory, and we moved the FE/BE (DATA and
PROG) files to the local drive C:... with no real difference compared to
PROG and DATA on the network server, or PROG local and DATA on the server.
I have an exact copy of the FE and BE, and it runs just fine on my P4
2.8GHz 1GB of memory.
AutoName Correct is turned off in Options.
I can not find any problem with my table design, or the combo query. 825
records is just not much of a load!
Any suggestions would be greatly appreciated.
Thanks,
Al Camp
combo is taking 15 minutes to load. The cursor is frozen, Ctrl-Break does
not stop the "Calculating".
Eventually, the "Calculating" goes away, and the combo works well.
If the client edits any records in the table that is the source for the
combo, the
"calculating" delay occurs again.
The combo (along with 3 other exaclty similar combos) is on a continuous
subform and only contains two fields
(AttendeeID and a Last/First concatenated field), and consists of only 825
items, sorted on Last/First. The ID is indexed NoDupes and key, and
Last/First are indexed DupesOK.
There is no criteria for the combo query. There is a NoShow True/False =
True field in the query
The PC is a 2Ghz P4 with 256K of memory, and we moved the FE/BE (DATA and
PROG) files to the local drive C:... with no real difference compared to
PROG and DATA on the network server, or PROG local and DATA on the server.
I have an exact copy of the FE and BE, and it runs just fine on my P4
2.8GHz 1GB of memory.
AutoName Correct is turned off in Options.
I can not find any problem with my table design, or the combo query. 825
records is just not much of a load!
Any suggestions would be greatly appreciated.
Thanks,
Al Camp