J
JM
Access 2000
We have an application, which is split into three databases. One is the
front end. The other two contain data. The dataflow is controlled by a
several switchboard buttons which invoke VBA and take data from the data
db1, creating and populating tables in data db2. The reason the data is so
split is because the results are used in OLAP and generate tables of up to
1Gb in size.
When the "processing" is done, you hear a beep followed a second or so later
by the Msgbox which caused the beep. This in itself is odd but not the main
problem. After that the screen fails to repaint and main database window
doesn't show the tables, queries, forms buttons etc. on the left. At the
bottom of the screen the status bar reads "Calculating . . ." but this
doesn't go away until you close the switchboard. Reopening the switchboard,
brings back the "Calculating" message.
Nothing is open except the switchboard, which is virtually unmodified from
the MS standard (I added a logo and it picks up a Const to show the version
number).
What might cause this?
I've gone through the vba code and every object is released using a set
tdf=nothing type statement, whether on not there is an error. More to the
point, when I do step through the code, the "Calculating error" does not
occur.
So I'm puzzled by what is causing this.
We have an application, which is split into three databases. One is the
front end. The other two contain data. The dataflow is controlled by a
several switchboard buttons which invoke VBA and take data from the data
db1, creating and populating tables in data db2. The reason the data is so
split is because the results are used in OLAP and generate tables of up to
1Gb in size.
When the "processing" is done, you hear a beep followed a second or so later
by the Msgbox which caused the beep. This in itself is odd but not the main
problem. After that the screen fails to repaint and main database window
doesn't show the tables, queries, forms buttons etc. on the left. At the
bottom of the screen the status bar reads "Calculating . . ." but this
doesn't go away until you close the switchboard. Reopening the switchboard,
brings back the "Calculating" message.
Nothing is open except the switchboard, which is virtually unmodified from
the MS standard (I added a logo and it picks up a Const to show the version
number).
What might cause this?
I've gone through the vba code and every object is released using a set
tdf=nothing type statement, whether on not there is an error. More to the
point, when I do step through the code, the "Calculating error" does not
occur.
So I'm puzzled by what is causing this.