S
SteveTyco
Access 2003, Windows 2000
I have 30 databases that run at the end of the month to collect performance
metrix; total run time is about 17 hrs. I have an additional database that
runs each of the 30 dbs one after the other and logs start time and end time.
Also in this db, with vba, I compact each of the 30 after the run is
complete. I use Windows 2000 "task scheduler" to start the main db on Sunday
afternoon - Of course I am not at work on Sundays.
The probem that I have is during the compacting of each of the 30 dbs after
their individual run completes. Some of them, after compacting, generate an
error and try to send the error report to MS. The problem with this is that
it stops the subsuquent dbs from running; the initial fix to this probem was
to not compact each after running and manually compact each db (remember
there are 30) when I would get in on Mondays. The compact error seemed
strange because the compact seemed to finished properly (the dbs would be
compacted) but would still generate an error.
This is what I found.
On the dbs that compact properly with out generating an error report for MS:
On opening the VB editor, my custom reference addin "Library.mda" (located
on C drive) does not show up immediatelly in the project window - causing the
current open database to be selected by default, it takes a few seconds to
see the Library.mda reference in the project window. Also, the trees for
each project (the current open db and the reference mda) are collapsed.
On the dbs that do not compact properly:
On opening the VB editor, my custom reference addin "Library.mda" shows up
in the project window immediatelly with the tree expanded and one of its
modules selected by default. I have just found that if I lock project for
viewing, with password protection, the problem goes away - the db compacts
without error.
Therefore, to correct the problem, I need to:
1) Lock project viewing with password protection for each of the 30 dbs
or
2) Figure out how to make the project windows act as described above.
Any help on 2) would be appreciated.
Thanks.
Steve
I have 30 databases that run at the end of the month to collect performance
metrix; total run time is about 17 hrs. I have an additional database that
runs each of the 30 dbs one after the other and logs start time and end time.
Also in this db, with vba, I compact each of the 30 after the run is
complete. I use Windows 2000 "task scheduler" to start the main db on Sunday
afternoon - Of course I am not at work on Sundays.
The probem that I have is during the compacting of each of the 30 dbs after
their individual run completes. Some of them, after compacting, generate an
error and try to send the error report to MS. The problem with this is that
it stops the subsuquent dbs from running; the initial fix to this probem was
to not compact each after running and manually compact each db (remember
there are 30) when I would get in on Mondays. The compact error seemed
strange because the compact seemed to finished properly (the dbs would be
compacted) but would still generate an error.
This is what I found.
On the dbs that compact properly with out generating an error report for MS:
On opening the VB editor, my custom reference addin "Library.mda" (located
on C drive) does not show up immediatelly in the project window - causing the
current open database to be selected by default, it takes a few seconds to
see the Library.mda reference in the project window. Also, the trees for
each project (the current open db and the reference mda) are collapsed.
On the dbs that do not compact properly:
On opening the VB editor, my custom reference addin "Library.mda" shows up
in the project window immediatelly with the tree expanded and one of its
modules selected by default. I have just found that if I lock project for
viewing, with password protection, the problem goes away - the db compacts
without error.
Therefore, to correct the problem, I need to:
1) Lock project viewing with password protection for each of the 30 dbs
or
2) Figure out how to make the project windows act as described above.
Any help on 2) would be appreciated.
Thanks.
Steve