Excel wrongly loading Access database add-in
With both Excel 2000 and 2002, Excel wrongly insists on trying to load any microsoft
database locking file (*.ldb file) located in the addins folder (I'm using Windows 2000
sp2.) The addins folder is "c:\documents and settings\Administrator\Application
Data\Microsoft\Addins"
That's where the Access add-ins belong, so why would Excel trying to load it? Is there
any workaround or fix?
To reproduce the error:
1. open any access 2000 or 2002 database.
2. open any custom add-in, such as Rick Fisher's Find and Replace (under Tools, Addins)
3. then open any excel 2000 or 2002 worksheet.
4. select Tools, Add-ins from the menu.
You will get the following error message, replacing <AccessAddinName> with the actual
filename of your addin (in my case, it was "replace9"):
" '<AccessAddinName>.ldb' cannot be accessed. The file may be read-only, or you may be
trying to access a read-only location. Or, the server the document is stored on may not
be responding."
It's an annoying problem because it interferes with automating Excel (if you need to load
any Excel addins as I do, such as the toolpak functions). I guess I'll have to look up
the Access code and use it to unload the access add-in everytime I want to use an excel
add-in.
