hi,
im using listboxes in my spreadsheet to show data (using ADO) saved in
access database..listbox updates on open_ excel event...
on the same spreadsheet i have a routin to compact that database which
i'm retriving dates from ..
it seems that the spreadsheet keeps the connection with database ( .ldb
file is on) which prevents the routine to compact database.. with err
message that admin has that db opened..

any help or direction to solve the issue?
thanks
Dim