M
Matthew Shea
I am using MS Access 2003. Sysinfo reports the versions as follows:
Access: 11.6566.8132 SP2
Jet 2.0: 4.00.7328.0
Jet 3.0: 4.00.6508.0
Mr problem is that when I try to access DAO.Database and DAO.Tabledef
variables in the Locals list of the MSVBA editor window, they are very slow
to respond. It takes 5-10 second to expand the database collection, 5-10
seconds to expand the Tabledefs collection, and 5-10 seconds to expand each
item in Tabledefs. The same is true for the Queries collection and its items.
Please read the 'Notes' section after the steps below for pertinent details
surrounding this problem.
The problem can be reproduced as follows:
1) Create a new, blank MDB file.
2) On the menus, click Insert > Module.
3) Paste the following code into the module:
Sub Main()
Dim db As DAO.Database
Set db = CurrentDb
Stop
Set db = Nothing
End Sub
4) Press F5 and double-click 'Main' in the list.
5) On the menus, click View > Locals Window.
6) In the locals window, double-click 'db', or single click the [+] next to
it. There is then a 5-10 second lockup.
7) Do the same for the Tabledefs collection. Again there is a 5-10 second
lockup.
8) And the same for each Tabledef item.
9) And the same for Queries collection and its items.
Why does this happen?
Notes:
1) This is NOT related to Name Autocorrect, as people keep telling me
ad-infinitum. I have turned it OFF and it does NOT help the problem.
2) This happens on all MDB files, old and new. AND I remember this happening
in MSACC2000 as well, but I do not remember if or how I fixed the problem.
3) These lockups are not limited to the Locals Window. If I close the Locals
Window and step through my code it still happens. If I step through my larger
code modules, and the pointer crosses a command such as Set t =
db.("MyTable") the module still locks up as it steps through that line of
code.
4) I have searched http://support.microsoft.com, and Googled it as well, but
I could not find anything helpful. Frankly I don't know what search terms to
use for this; I've tried many and got nothing.
Thanks,
Matthew Shea, Studio Technology Manager, CBS Radio
KMPS 94.1 ~ KZOK 102.5 ~ KBKS 106.1 ~ KJAQ 96.5 ~ KPTK 1090
1000 Dexter Avenue North ~ Suite 100 ~ Seattle, Washington 98109
(206) 805-1244 ~ (e-mail address removed)
Access: 11.6566.8132 SP2
Jet 2.0: 4.00.7328.0
Jet 3.0: 4.00.6508.0
Mr problem is that when I try to access DAO.Database and DAO.Tabledef
variables in the Locals list of the MSVBA editor window, they are very slow
to respond. It takes 5-10 second to expand the database collection, 5-10
seconds to expand the Tabledefs collection, and 5-10 seconds to expand each
item in Tabledefs. The same is true for the Queries collection and its items.
Please read the 'Notes' section after the steps below for pertinent details
surrounding this problem.
The problem can be reproduced as follows:
1) Create a new, blank MDB file.
2) On the menus, click Insert > Module.
3) Paste the following code into the module:
Sub Main()
Dim db As DAO.Database
Set db = CurrentDb
Stop
Set db = Nothing
End Sub
4) Press F5 and double-click 'Main' in the list.
5) On the menus, click View > Locals Window.
6) In the locals window, double-click 'db', or single click the [+] next to
it. There is then a 5-10 second lockup.
7) Do the same for the Tabledefs collection. Again there is a 5-10 second
lockup.
8) And the same for each Tabledef item.
9) And the same for Queries collection and its items.
Why does this happen?
Notes:
1) This is NOT related to Name Autocorrect, as people keep telling me
ad-infinitum. I have turned it OFF and it does NOT help the problem.
2) This happens on all MDB files, old and new. AND I remember this happening
in MSACC2000 as well, but I do not remember if or how I fixed the problem.
3) These lockups are not limited to the Locals Window. If I close the Locals
Window and step through my code it still happens. If I step through my larger
code modules, and the pointer crosses a command such as Set t =
db.("MyTable") the module still locks up as it steps through that line of
code.
4) I have searched http://support.microsoft.com, and Googled it as well, but
I could not find anything helpful. Frankly I don't know what search terms to
use for this; I've tried many and got nothing.
Thanks,
Matthew Shea, Studio Technology Manager, CBS Radio
KMPS 94.1 ~ KZOK 102.5 ~ KBKS 106.1 ~ KJAQ 96.5 ~ KPTK 1090
1000 Dexter Avenue North ~ Suite 100 ~ Seattle, Washington 98109
(206) 805-1244 ~ (e-mail address removed)