Access Add-in Manager

  • Thread starter Thread starter Guest
  • Start date Start date
Probably because you haven't installed any onto your PC.

IIRC Add-In manager looks for .mde and .mda files in a
default folder that varies depending on your operating
system. If your Add-Ins are somewhere else you'll have to
browse for them.

I don't remember if there are any add-ins in the Office
install set.

--
Nick Coe (UK)
www.alphacos.co.uk

---

Thos said:
Why does Access Add-in Manager not have any available
Click to expand...
add-ins listed?
 
Earlier versions of Access (such as Access 97, but I don't remember about
Access 95) listed the default Add-ins (Database Splitter, Linked Table
Manager, Switchboard Manager and Upsizing Wizard), in the "Add-ins" menu
item on the Tools menu. Access 2K and later have these default Add-ins
listed in the Tools menu -> Database Utilities. The Tools menu -> Add-ins
item is now for user-defined Add-ins, so if you haven't added any Add-ins to
your computer, there won't be any Add-in names listed here.

Add-ins can be MDA, MDE, and even MDB files. The major difference between a
regular database file and an Add-in database is that the Add-in includes a
special system table that the Add-in Manager can read and then store these
values in the Windows Registry, so that the database can be used as an
Add-in with other Access databases. During the process of creating the
Add-in, the Add-in Manager registers the Add-in in the Windows Registry and
copies the Add-in database file to the default Access Add-in folder.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
I used to have (before I clean-installed Win/XP and had to reinstall
everything) a nifty add-on which I think came with Office Developer 2000
which would auto-magically add error-handling code to a procedure or
function. I didn't go back and reinstall all previous versions, but
I've installed VS Tools for Office, but it hasn't reappeared. Any idea
how I get it back again?

Kevin

_______________________________________________________

Earlier versions of Access (such as Access 97, but I don't remember about
Access 95) listed the default Add-ins (Database Splitter, Linked Table
Manager, Switchboard Manager and Upsizing Wizard), in the "Add-ins" menu
item on the Tools menu. Access 2K and later have these default Add-ins
listed in the Tools menu -> Database Utilities. The Tools menu -> Add-ins
item is now for user-defined Add-ins, so if you haven't added any Add-ins to
your computer, there won't be any Add-in names listed here.

Add-ins can be MDA, MDE, and even MDB files. The major difference between a
regular database file and an Add-in database is that the Add-in includes a
special system table that the Add-in Manager can read and then store these
values in the Windows Registry, so that the database can be used as an
Add-in with other Access databases. During the process of creating the
Add-in, the Add-in Manager registers the Add-in in the Windows Registry and
copies the Add-in database file to the default Access Add-in folder.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Any human can read my reply E-mail address and should alter it so that a
message will be forwarded to me. Spammers are free to use my UNALTERED
reply E-mail address. I will *never* get those messages!)
 
You'd need to re-install it from the Office 2000 Developer CD, it was not
included in any later versions.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
Hmmmm... MS giveth and MS taketh away...

Thanks, Brendan. Can I install that even though I no longer have Office
2000 on the machine?

Kevin
 
I'm afraid I can't say for sure. On my old PC, I had multiple versions of
Access installed, and I know that the Office 2000 Developer add-ins worked
with Access 2002, but I have never tested them with Access 2003.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
I had Access 2003 installed, complete with Office 2003 Developer Extensions.
The main reason for the latter is the Property Scanner, kind of a forensic
utility to search anything in an Access app for a string. I also got to like
the Error Handler Add-In from Office 2000 Developer. OK, re-install Office
2000 Premium (at least Access thereof) and add the Developer Tools. Big
mistake!

Here is the proper sequence: Access 2000, Office 2000 Developer Tools,
Access 2003 and finally Office 2003 Developer Extensions. Now, I have the
Property Scanner Add-In (in Access window) and a number of add-ins form the
old 2000 version (in the code window).

This leads to a question with the error handler. I already edited the
template file (.eht) to shorten some comments. However, it retains an
annoying property. The variable $$N is supposed to contain the 'fully
qualified name of the procedure/function'. It does but it also adds a totally
superfluous comment after the Msgbox line. I am trying to keep my code
printable without uncontrolled line wraps. Does anybody have a hint where
this variable is generated and how one could edit its content?
 
Back
Top