P
pic078 via AccessMonster.com
Hi all - weird situation going on here:
Background:
I have a front-end/back-end database set up via two Access files both located
on my desktop, with all my tables in the former, the forms, queries, modules
in the latter. My front-end has a query-by-form component with several multi-
select mistboxes and combo boxes from which user can select from - the
results/data are spit out into new Excel worksheet via automation/VBA.
Problem:
After I run several complex searches, producing a new excel worksheet each
time and closing out Excel without saving any workbooks, and close out of the
application, the Access file "freezes" when I attempt to reopen it shortly
thereafter - this also happens occasionally even when I don't use the QBF
feature - in other words, I double-click the Access file icon to open, two
locked access file icons quickly appear on the desktop indicating that the
database is in fact opening (both backend and frontend), but no windows/forms
appear! The new locked file icons cannot be deleted - the only way to get
rid of them and to reopen the database exclusively is by rebooting the
machine (and maybe using the task manager).
Additional Notes: There are no error messages unless I try to open the same
file again by opening Access first and attempting to modify any objects in
design view - all of my code works fine - I made sure all of my object
variables are set to "Nothing" to reclaim memory in case this is a memory
issue. There are never multiple instances of Excel open at any time. The
file is also set to compact on close. Maybe the file is corrupt?
Optimization issue I'm missing here? Any help/feedback would be greatly
appreciated. Thanks,
-Chris
Background:
I have a front-end/back-end database set up via two Access files both located
on my desktop, with all my tables in the former, the forms, queries, modules
in the latter. My front-end has a query-by-form component with several multi-
select mistboxes and combo boxes from which user can select from - the
results/data are spit out into new Excel worksheet via automation/VBA.
Problem:
After I run several complex searches, producing a new excel worksheet each
time and closing out Excel without saving any workbooks, and close out of the
application, the Access file "freezes" when I attempt to reopen it shortly
thereafter - this also happens occasionally even when I don't use the QBF
feature - in other words, I double-click the Access file icon to open, two
locked access file icons quickly appear on the desktop indicating that the
database is in fact opening (both backend and frontend), but no windows/forms
appear! The new locked file icons cannot be deleted - the only way to get
rid of them and to reopen the database exclusively is by rebooting the
machine (and maybe using the task manager).
Additional Notes: There are no error messages unless I try to open the same
file again by opening Access first and attempting to modify any objects in
design view - all of my code works fine - I made sure all of my object
variables are set to "Nothing" to reclaim memory in case this is a memory
issue. There are never multiple instances of Excel open at any time. The
file is also set to compact on close. Maybe the file is corrupt?
Optimization issue I'm missing here? Any help/feedback would be greatly
appreciated. Thanks,
-Chris